Re: [PHP] Inserting a variable into a mysql_query() statement

2002-10-16 Thread Rick Emery
$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 va

Re: [PHP] Inserting a variable into a mysql_query() statement

2002-10-16 Thread Marek Kilimajer
You very likely need to use $_REQUEST[hidden_manuf_id] in your first example, which is almost correct otherwise( for security reasons, also put single quotes around it) Phil Clark wrote: >I'm trying to insert the variable $hidden_manuf_id into a mysql_query() >statement. > >If i do this: >mysq

Re: [PHP] Inserting a variable into a mysql_query() statement

2002-10-15 Thread Jason Wong
On Tuesday 15 October 2002 12:54, 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()); That should work iff manufacturer is a

Re: [PHP] Inserting a variable into a mysql_query() statement

2002-10-14 Thread Timothy Hitchens
Single around the variable mysql_query("DELETE FROM product WHERE manufacturer='$hidden_manuf_id'",$bb) Timothy Hitchens [EMAIL PROTECTED] 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