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 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. 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 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'"); Link to comment https://forums.phpfreaks.com/topic/141206-strange-one/#findComment-739727 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.