Re: [PHP] Update db with $_POST

2005-03-16 Thread Danny Brow
On Wed, 2005-03-16 at 16:50 +1000, Ligaya Turmelle wrote: > assuming you are using PEAR DB - > > $result =& $db->query("UPDATE items SET (item_name, item_desc, > item_price, extraprice) VALUES (?,?,?,?) WHERE item_id = 3", > array($_POST['title'], $_POST['description'], $_POST['price'], > $_PO

Re: [PHP] Update db with $_POST

2005-03-15 Thread Ligaya Turmelle
assuming you are using PEAR DB - $result =& $db->query("UPDATE items SET (item_name, item_desc, item_price, extraprice) VALUES (?,?,?,?) WHERE item_id = 3", array($_POST['title'], $_POST['description'], $_POST['price'], $_POST['extraprice'])); if (PEAR::isError($result)) { echo "Error: There

[PHP] Update db with $_POST

2005-03-15 Thread Danny Brow
I'm trying to update some form data with this db update query and it's not working, I'm not getting an error either. $db->query("UPDATE items SET item_name = $_POST[title], item_desc = $_POST[description], item_price = $_POST[price], extraprice = $_POST[extraprice] WHERE item_id = 3"); & I've t