Code: Select all
$check_query = "select * from active where ip='$ip' and username='$username'";
$check_result = mysql_query($check_query, $connection) or die(mysql_error());You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '* ip='ip address' and username='guest'' at line
and other sql statements return errors saying the syntax is incorrect and in the error says the check for proper syntax and starts the statement right in the middle of it.
i checked the online manual for hours, and couldn't find much of anything except for sql statements that look much the same way that i write my own.
the server uses mysql 4.0.15. anyone know what could be going on or can shed some light on this?