strange one...

[Devon11]

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

[PFMaBiSmAd]

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.

[Devon11]

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

[fenway]

Also, why run two update queries? why not:

 

        mysql_query("UPDATE users SET on='ON',ip='$ip' WHERE username = '$username'");