how do i echo a variable in a php mysql query ? - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

toasty525 · 09-16-2009, 04:30 PM

I have the following PHP MySql query:

PHP Code:


			
$query="SELECT * FROM hosts WHERE php='$isphp' AND asp='$isasp' AND bandwidth>='$isbandwidth' AND space>='$isspace' ORDER BY '$order_by' $sort";

$sort = "DESC"

can anyone tell me where i am going wrong with the above query ? i know its somthing to do with the $sort variable.

Thanks,
Mark.

toasty525 · 09-16-2009, 05:30 PM

I figured out where i went wrong, i used ' ' where i shouldnt of. The end of the PHP mysql query should read:

PHP Code:


			
ORDER BY $order_by $sort";

Not:

PHP Code:


			
ORDER BY '$order_by' $sort";