mysql update query creates 2 db entries?
Posted: Thu Jul 03, 2003 12:03 pm
I have an update query:
parsing right after the initial information is added to the database, and instead of just updating the sql row it just added, it creates an entire new one. Does anyone know why this would happen or if there would be an alternative?
I tried including this in the original statement, but the original is a pre-made shopping cart and trying to set it up the same way the initial programming is like didnt' seem to add any information to the database. thanks for help!
Code: Select all
<?php
$sql = "UPDATE customers SET vendor_id=$vendor_id WHERE customers_id=$customer_id";
$sql_update = mysql_query($sql) or die(mysql_error());
?>I tried including this in the original statement, but the original is a pre-made shopping cart and trying to set it up the same way the initial programming is like didnt' seem to add any information to the database. thanks for help!