I have 3 tables
users -> users.id - users.email - users.username - users.password
reports -> reports.id - report_types.id - reports.date - reports.url
report_types -> report_types.id - report_types.name
tokens -> tokens.id - users.id - reports.id - tokens.start - tokens.end
I have a select box that contains the reports, it must show all reports but I want to option text color to be black when a token exist and light gray when a token table is NULL
<option value="reports.id">report_types.name - reports.date</option>
It seems to me that there will be a nested select but not sure
a more challenging part is the Select for the tokens needs to be in a if statement that returns false.
If more clarification is needed let me know.