[SOLVED] mySQL error help

[nbarone]

here is my code:

$query = (empty($_GET['series'])) ? "select * from theater_media where media_ID = '$prod_id'" :
								"select media_ID," . 
									   "media_Date," .
									   "media_Series," . 
									   "media_Speaker," . 
									   "media_Title" . 
								"from theater_media where media_Series='".urldecode(str_replace("'","''",$_GET['series']))."'";

 

 

here is the error:

 

Error retrieving results from database. 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 media_Series='Elephants In The Church'' at line 1

 

any help would be appreciated, thank you!

[gevans]

echo out the query before it gets executed so you can see it

[nbarone]

problem solved. was missing a space in front of "from"