Jump to content


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


**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.