Jump to content

[SOLVED] mySQL error help


nbarone

Recommended Posts

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!

Link to comment
https://forums.phpfreaks.com/topic/156659-solved-mysql-error-help/
Share on other sites

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.