#10 Query syntax error when logging in for the first time
After logging in, the following error appears in both frames:
Query failed:
SELECT wo.wo_id AS 'WO', wo.priority AS 'Priority', wo.equipment AS 'Equipment', wo.descriptive_text AS 'Description', wo.wo_status AS 'Status', wo.submit_date AS 'Submit Date', wo.complete_date AS 'Completed Date', m.lname AS 'Mechanic', m.fname, m.id, p.description as 'Priority' , m.lname, m.fname, m.id, p.description as description FROM work_orders AS wo LEFT JOIN mechanics AS m ON wo.mechanic_id = m.id LEFT JOIN priority AS p ON wo.priority = p.priority WHERE updated > 0000-00-00 00:00:00
MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '00 : 00 : 00
LIMIT 0, 30' at line 1
The fix is to enclose the date (right after the "WHERE updated >" section) in single quotes:
...WHERE updated > '0000-00-00'...
Logged In: NO
Additional info:
The error lies in the "NEW_TO_YOU" query:
WHERE updated > " . $_SESSION['last_login'] . "
should be
WHERE updated > " . '$_SESSION['last_login']' . "
Notice the single quotes enclosing "$_SESSION['last_login']"