PHP MySQL Update query

[slickboyj]

Good Afternoon,

 

$conn = mysql_connect(SQL_HOST, SQL_USER, SQL_PASS)
or die ('Could not conncect to MySQL. ' .mysql_error());

mysql_select_db(SQL_DB, $conn) or die (mysql_error());

$id = $_REQUEST["product_id"];	
$publish = $_REQUEST["publish"];   

$sql = "UPDATE products SET publish = 0 WHERE publish = $publish";
				  	     
$result = mysql_query($sql) or die (mysql_error());


mysql_close();

 

What I'm trying to to is update publish from  a 1 to 0

Nothing is updating at all and I'm at a point where I'm gonna go bananas. 

 

Any help would be great.

 

Thanks,

Joe

[jworisek]

have you checked that you have update privileges for that user?  I'm assuming you verified that the variables are actually being put in the query by echoing it back?