Need help building a query

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.

MySQL Server

Last Comment

impressionexpress

8/22/2022 - Mon

impressionexpress

1/27/2020

ASKER

This is what I have so far, I need to add the table tokens and if a token exists, leave the color in the option text black in the select box
if($_SESSION['perm'] < 80) and token is null then I use a different color and leave the value of the option empty. also it needs to compare between start and end date

$client_id = 55;
SELECT 
	r.report_id, 
	r.report_start, 
	r.report_end, 
	rt.report_type_name
FROM reports AS r
INNER JOIN report_types AS rt
ON r.report_id = rt.report_type_id
WHERE r.client_id = " . $client_id

Open in new window

ASKER CERTIFIED SOLUTION

impressionexpress

1/27/2020

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.