When I use the following script, I do not get any errors but the database is not updated. The database is accessed but the update fails.
<?
MYSQL_CONNECT('localhost', '', '') OR DIE('Unable to connect to database');
@mysql_select_db( 'testdb') or die( 'Unable to select database');
$query="UPDATE customers SET f_name='$f_name',l_name='$l_name',phone='$phone',alt_phone='$alt_phone' WHERE cust_id='$cust_id'";
$query2="UPDATE appoitment SET appt_date='$appt_date',appt_time='$appt_time',trk_make='$trk_make',trk_year='$trk_year',sb_lb='$sb_lb',trk_color='$trk_color',rail='$rail',wait='$wait',notes='$notes' WHERE appt_id='$appt_id'";
mysql_query($query);
mysql_query($query2);
mysql_close();
?>
Any ideas?