So I have the following update statement that is supposed to update a record
"UPDATE Assignments LEFT JOIN results ON Assignments.username= results.username SET Assignments.active = 'N' WHERE results.username = '$uid' and results.datestarted >= '$scres' and results.passorfail = 'P' ";"
Basically what this does is allow me to show courses on the main user page that are assigned to the user by using active = 'Y'. The update statement above should only be setting active to N when the user has passed the course, and the datestarted is greater then the current time - 1hour...now the $scres when echoed on the page gives me exactly what I want, and is in the same format as my results.datestarted column, but for some reason the update statement is always updating everyting in the table for the $uid who passed to N....can't figure out why
