[PHP] Order by

[Si Jones]

>start the quotes again...
>
>$specs_query = mysql_query("select title, information from spec where
>product=".$id." order by id asc");
>
>  
>
Why do you split the string?

When all you need to do is

$specs_query = mysql_query("select title, information from spec where

product = $id order by id asc");

because your using " and not ' it will fill the varible in for you.

If it was a string and you need to surround the string then it would be

$specs_query = mysql_query("select title, information from spec where

product = '{$id}' order by id asc");

That would fill the variable in and the single quotes required for sql.

Regards,