Re: [PHP] Update db with $_POST

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

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

Re: [PHP] update db

It's just like a SELECT, only you send an UPDATE query. $query = "select * from people"; $people = mysql_query($query) or die(mysql_error()); . . . $query = "update people set name = 'Fred' where lastname = 'Flintstone'"; mysql_query($query) or die(mysql_error()); You can send *ANY* query to the