Jump to content

[SOLVED] mysql question - syntax error


TimUSA

Recommended Posts

whats wrong with this query?

SELECT race_table.raceID, race_table.raceDate, pts_table.raceID, pts_table.skipperName, pts_table.position, pts_table.racePoints
	WHERE race_table.seriesID = '6'
	FROM race_table
	LEFT JOIN pts_table ON race_table.raceID = pts_table.raceID

#1064 - 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 'WHERE race_table.seriesID = '6'  FROM race_table  LEFT JOIN pts_table ON race_ta' at line 1

 

my guess is i am doing the where wrong, because the query worked before i put it there?

Link to comment
https://forums.phpfreaks.com/topic/85298-solved-mysql-question-syntax-error/
Share on other sites

where clause should be at the end of your select statement

SELECT race_table.raceID, race_table.raceDate, pts_table.raceID, pts_table.skipperName, pts_table.position, pts_table.racePoints
	FROM race_table
	LEFT JOIN pts_table ON race_table.raceID = pts_table.raceID
	WHERE race_table.seriesID = '6'

 

beaten to that any way there you go

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.