$query = "DELETE FROM product WHERE manufacturer=\"$hidden_manuf_id\"";
mysql_query($query,$bb) or die(mysql_error());

or:

mysql_query("DELETE FROM product WHERE manufacturer=\"$hidden_manuf_id\"", $bb);

=================================
Phil Clark wrote:

>I'm trying to insert the variable $hidden_manuf_id into a mysql_query()
>statement.
>
>If i do this:
>mysql_query("DELETE FROM product WHERE manufacturer=$hidden_manuf_id",$bb)
>or die(mysql_error());
>PHP server doesn't see the variable because it is inside the string
>quotes"".
>
>If I do this:
>mysql_query("DELETE FROM product WHERE manufacturer="$hidden_manuf_id,$bb)
>or die(mysql_error());
>PHP server reports a parsing error.
>
>What is the correct syntax?  ($bb is correctly defined.)



Reply via email to