[PHP] Order by

[Jake McHenry]

----- Original Message ----- 
From: "Karl-Heinz Schulz" <karlheinz at khschulz.com>
To: <php-general at lists.php.net>
Sent: Tuesday, August 03, 2004 10:19 PM
Subject: [PHP] Order by


> $specs_query = mysql_query("select title, information from spec where
> product=".$id order by id asc);
>
> But it will create the error.
>
> Parse error: parse error, unexpected T_STRING in
/www/docs/view_product.php
> on line 144



start the quotes again...

$specs_query = mysql_query("select title, information from spec where
product=".$id." order by id asc");


Thanks,
Jake McHenry

MIS Coordinator
Nittany Travel
http://www.nittanytravel.com
570.748.6611 x108