I've been all over these discussions and still cannot find the syntax that works!
When I echo $co and $bus, they both print on screen as they should. But when I try to update the mysql records using the following php, the business_name field data gets erased instead of changed.
This is my php. I've tried other ways too with same outcome.
Please help!!! Thanks!
$co = $_POST['contact_company']; $bus = $row_contact['business_name']; $query = "UPDATE events SET business_name='".$co."' WHERE business_name='".$bus."'"; $result = mysql_query($query, $events) or die(mysql_error());