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. Quote Link to comment 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 Quote Link to comment 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 Quote Link to comment 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.