Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

help with mysql query


daithi

Recommended Posts

can anyone tell me what is wrong with the following - i need to include it on a new page for updating products...any help is appreciated.

 

$result5 = mysql_query("UPDATE products

SET

products_quantity='$property_quantity_form',

products_model='$property_model_form' WHERE $products_id = '334');

 

it just errors on the page.....

 

also, i need to change $products_id = '334' to dynamicly pick up the id of the product i am editing - the products id does show on the page as $products_id_form

 

 

please...

Link to comment
Share on other sites

$result5 = mysql_query("UPDATE products

SET

products_quantity='$property_quantity_form',

products_model='$property_model_form' WHERE $products_id = '334');

 

got it, (well atleast this works) should have been:

$result5 = mysql_query("UPDATE products

SET

products_quantity='$property_quantity_form',

products_model='$property_model_form' WHERE products_id = '$products_id_form'");

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...