Devon11 Posted January 17, 2009 Share Posted January 17, 2009 ok .. i have this mysql_query("UPDATE users SET on='ON' WHERE username = '$username'"); mysql_query("UPDATE users SET ip='$ip' WHERE username = '$username'"); and the 'ip' gets a value but 'on' don't get any value , why? (the lines are one after another like here) on varchar(255) latin1_swedish_ci ip varchar(255) latin1_swedish_ci Quote Link to comment https://forums.phpfreaks.com/topic/141206-strange-one/ Share on other sites More sharing options...
PFMaBiSmAd Posted January 17, 2009 Share Posted January 17, 2009 Because ON is a reserved word and you should not have a column named using it - http://dev.mysql.com/doc/refman/6.0/en/reserved-words.html Also, your code has no error checking, error reporting, or error recovery logic in to to detect if the query worked or failed, tell you that it failed, or take appropriate action when it fails. Quote Link to comment https://forums.phpfreaks.com/topic/141206-strange-one/#findComment-739108 Share on other sites More sharing options...
Devon11 Posted January 17, 2009 Author Share Posted January 17, 2009 Because ON is a reserved word and you should not have a column named using it - http://Dev.mysql.com/doc/refman/6.0/en/reserved-words.html oops , i really didn't knew thx Quote Link to comment https://forums.phpfreaks.com/topic/141206-strange-one/#findComment-739131 Share on other sites More sharing options...
fenway Posted January 18, 2009 Share Posted January 18, 2009 Also, why run two update queries? why not: mysql_query("UPDATE users SET on='ON',ip='$ip' WHERE username = '$username'"); Quote Link to comment https://forums.phpfreaks.com/topic/141206-strange-one/#findComment-739727 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.