Connected to MySQLYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
<?
$hostname = "localhost";
$username= "***user";
$password= "jpass**";
$dbid="DB";
$link=mysql_connect($hostname, $username, $password);
mysql_select_db($dbid) or die ("Unable to connect to MySQL");
print "Connected to MySQL";
$c_name = addslashes($_POST['c_name']);
$contact_name = addslashes($_POST['contact_name']);
$phone = addslashes($_POST['phone']);
$email = addslashes($_POST['email']);
$j_location = addslashes($_POST['j_location']);
$start_date = addslashes($_POST['start_date']);
$hours = addslashes($_POST['hours']);
$ceiling_ht = addslashes($_POST['ceiling_ht']);
$floor = addslashes($_POST['floor']);
$dock_yes = addslashes($_POST['dock_yes']);
$dock_no = addslashes($_POST['dock_no']);
$dock_size = addslashes($_POST['dock_size']);
$ground_yes = addslashes($_POST['ground_yes']);
............
$update="UPDATE test SET c_name ='$c_name', contact_name ='$contact_name', phone='$phone', email='$email', j_location='$j_location', start_date='$start_date', hours='$hours', ceiling_ht='$ceiling_ht', floor ='$floor', dock_yes='$dock_yes', dock_no='$dock_no', dock_size='$dock_size', ground_yes='$ground_yes',ground_no='$ground_no', ground_size='$ground_size', crane_yes='$crane_yes',crane_no='$crane_no', crane_size='$crane_size', b_manuf='$b_manuf', b_voltage='$b_voltage', b_amperage='$b_amperage', p_manuf='$p_manuf', p_voltage='$p_voltage', p_amperage='$p_amperage', amp_of_equipment='$amp_of_equipment',distance='$distance', machine_manuf='$machine_manuf', serial='$serial', weight='$weight',ht='$ht',wt='$wt',lt='$lt',p_address='$p_address', p_city='$p_city', p_state='$p_state', d_address='$d_address', d_city='$d_city', d_state='$d_state', additional='$additional',soil_condition='$soil_condition',size='$size', cad_drawings_yes='$cad_drawings_yes', cad_drawings_no='$cad_drawings_no',dimensions_from_wall='$dimensions_from_wall',pipe_size='pipe_size', length='$length', material='$material', substance='$substance', lifts_yes='$lifts_yes',lifts_no='$lifts_no',lift_size='$lift_size',scissors='$scissors',boom='$boom',submitted=CURDATE() WHERE q_id=$id";
$rez=mysql_query($update) or die(mysql_error());
echo "Update Successful!";
?>
[Ovu poruku je menjao Nemanja Avramović dana 09.01.2007. u 17:50 GMT+1]