PHP MySQL query variable usage
Posted: Fri Dec 25, 2009 11:02 pm
Code: Select all
$result = mysql_query("SELECT filename, ext FROM files ORDER BY '$sort'") or die(mysql_error());A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
$result = mysql_query("SELECT filename, ext FROM files ORDER BY '$sort'") or die(mysql_error());Code: Select all
$result = mysql_query("SELECT filename, ext FROM files ORDER BY $sort") or die(mysql_error());Syntax error.PCSpectra wrote:Try:
I don't think those single quotes aorund $sort are required or desired.Code: Select all
$result = mysql_query("SELECT filename, ext FROM files ORDER BY $sort") or die(mysql_error());
Cheers,
Alex