impressionexpress
asked on
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.
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_
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
Open in new window