Posted by Danny Brow on 03/16/05 00:33

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 tried this:

$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']));


Thanks,
Dan.

• Next in thread: RE: Update db with $_POST
• Prev in thread: Re: [PHP] Quoting and $_POST['Name'] problem
• Next in forum: Re: [PHP] Can I use ftp_put to bypass upload_max_filesize?
• Prev in forum: Re: [PHP] Re: PHP-CLI Debugging Question
• Thread view: $_POST

[Reply to this message]