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 Quote 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 Quote Link to comment https://forums.phpfreaks.com/topic/174300-multiple-where-statements/#findComment-918911 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.