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 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 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
Archived
This topic is now archived and is closed to further replies.