Thank you - stupid me
-----Original Message-----
From: Wesley Furgiuele [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 03, 2004 10:27 PM
To: Karl-Heinz Schulz
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] Order by
Looks like you just forgot some quotes:
$specs_query = mysql_query( "select title, information from spec where
product=".$id." order by id asc" );
Or just move your quotes to the end -- I think you should be fine:
$specs_query = mysql_query( "select title, information from spec where
product = $id order by id asc" );
Wes
On Aug 3, 2004, at 10:19 PM, Karl-Heinz Schulz wrote:
> How can I use the "Order" statement for this query?
>
> $specs_query = mysql_query("select title, information from spec where
> product=".$id);
>
> I tried to use
>
> $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
>
> What am I doing wrong?
>
> TIA
>
> Karl-Heinz
>
> Tracking #: 28B73BEA7EBF0B4D89E64E5EA406BF5EC2EA6912
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
