Code Forums - View Single Post

teknomage1 · 09-02-2005, 09:59 PM

Shouldn't this line

PHP Code:


			
$query='SELECT * FROM `memfiles` WHERE `field` = \'$field\' ';

look like this instead

PHP Code:


			
$query=sprintf("SELECT * FROM `memfiles` WHERE `field` = '%s'", $field);

The main thing is $field won't get interpolated into a single quoted string, use sprintf or double quotes.

09-02-2005, 09:59 PM	#2 (permalink)
teknomage1 Jack of all trades Join Date: Feb 2005 Location: Los Angeles Posts: 598	Shouldn't this line PHP Code: $query='SELECT * FROM `memfiles` WHERE `field` = \'$field\' '; look like this instead PHP Code: $query=sprintf("SELECT * FROM `memfiles` WHERE `field` = '%s'", $field); The main thing is $field won't get interpolated into a single quoted string, use sprintf or double quotes. __________________ Stop intellectual property from infringing on me