Jump to content

Archived

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

sjones

**solved** A simple query ?? - I hope

Recommended Posts

Can someone give me an idea of how to put a INSERT statement - with a WHERE clause. below is my blown example. I am calling the vendors from the database, allowing one of them to be selected, then hit an active or inactive radio button (active_id) I would like to upload the active_id to the vendors table where the $_POST['vendor_id'] = the vendor_id in the table. Any Thoughts ????

if(!empty($_POST['submit'])) {
[b]$qry = mysql_query("INSERT INTO vendors (active_id) VALUES ('".$_POST['active_id']."') WHERE (vendor_id) = ('".$_POST['vendor_id']."');");[/b]
if($qry) { echo "<span class='content_blank'><strong>Vendor has been activated</strong></span>"; }
else { echo "<span class='content_blank'><strong>Error activating vendor</strong></span>"; }
}

Share this post


Link to post
Share on other sites
You need to use an UPDATE statement, not an INSERT.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.