jmaccs64 Posted September 15, 2009 Share Posted September 15, 2009 Should this work? UPDATE acad_adv SET present = 1, teacher_complete = '$teacher_complete', comp_timestamp = '$time' WHERE acad_adv_id={$k} AND teacher_complete = NULL I think there is a problem, with the multiple WHERE statements... Thanks in Advance! Joe Link to comment https://forums.phpfreaks.com/topic/174300-multiple-where-statements/ Share on other sites More sharing options...
artacus Posted September 15, 2009 Share Posted September 15, 2009 You can't do = with NULL. Well you can but it won't do what you want. Always use IS NULL or IS NOT NULL ... teacher_complete IS NULL Link to comment https://forums.phpfreaks.com/topic/174300-multiple-where-statements/#findComment-918911 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.