Thomisback Posted June 21, 2008 Share Posted June 21, 2008 Hi, sorry for this beginner question but I can't figure it out, the following 2 queries: $result = mysql_query("SELECT * FROM phaos_users WHERE UID='$userid'") or die(mysql_error()); $num_rows = mysql_num_rows($result); $check = mysql_query("SELECT * FROM phaos_users UID='$userid'") or die(mysql_error()); while($row = mysql_fetch_array($check)){ $username = $row['username']; } Give me this 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 '='1033023711'' at line 1 1033023711 is the user ID, does anyone see what's wrong with my queries? Kind regards. Link to comment https://forums.phpfreaks.com/topic/111229-solved-you-have-an-error-in-your-sql-syntax/ Share on other sites More sharing options...
Mattyspatty Posted June 21, 2008 Share Posted June 21, 2008 $check = mysql_query("SELECT * FROM phaos_users UID='$userid'") you missed a WHERE Link to comment https://forums.phpfreaks.com/topic/111229-solved-you-have-an-error-in-your-sql-syntax/#findComment-570909 Share on other sites More sharing options...
Thomisback Posted June 21, 2008 Author Share Posted June 21, 2008 Lol I just noticed it, sorry stupid mistake Link to comment https://forums.phpfreaks.com/topic/111229-solved-you-have-an-error-in-your-sql-syntax/#findComment-570910 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.