snowdog Posted February 9, 2013 Share Posted February 9, 2013 My eyes just don't see it. I am sure it is simple and stupid. Here is the code and error $query_check = "select * from spares where level = '$level', skill = '$skill', date = '$date', time = '$game_time', team = '$team_name', position = '$position', player_id = '$player_id'"; $result_check = mysql_query($query_check) or die('Query failed: ' . mysql_error()); Query failed: 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 ' skill = 'b', date = '2013-02-24', time = '8:30', team = '8', position = 'f', pl' at line 1 Thanks Snowdog Quote Link to comment https://forums.phpfreaks.com/topic/274250-eyes-needed-for-sql-query-not-working/ Share on other sites More sharing options...
snowdog Posted February 9, 2013 Author Share Posted February 9, 2013 Stupid me, the , needs to be AND . Solved Snowdog Quote Link to comment https://forums.phpfreaks.com/topic/274250-eyes-needed-for-sql-query-not-working/#findComment-1411296 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.