Can anyone tell me what is wrong with this query??
<?php
if ($custname==""||$custroad==""||$custcity==""||$custpost==""||$custtelone=="")
{
echo "<font face='Verdana, Arial, Helvetica, sans-serif' size='2' color ='FF0000'>Please make sure you have filled in the form correctly.</font><BR><BR>";
echo "<left><FORM><INPUT TYPE='BUTTON' VALUE='Back' ONCLICK='history.go(-1)'></FORM></left>";
}
else
{
if (isset($hostname) and isset($database) and isset($db_login) and isset($db_pass))
{ // variable check
$dbconn = mysql_connect($hostname, $db_login, $db_pass) or die("ERROR : Could not connect"); // connects to host
print "<div align='left'>Connected to host.<br>";
mysql_select_db($database) or die("ERROR : Could not select database"); // selecting databes
print "Database selected.<br>";
$query = "UPDATE aq_info SET (cust_name='$custname', cust_road=$custroad', cust_city='$custcity', cust_post='$custpost', cust_telone='$custtelone', cust_teltwo='$custteltwo', cust_fax='$custfax', comp_name='$compname', comp_road=$comproad', comp_city='$compcity', comp_post='$comppost', comp_telone='$comptelone', comp_teltwo='$compteltwo', comp_fax='$compfax') WHERE uid = '$uid'";
$result = mysql_query($query) or die("ERROR : Query failed");
print "Customer details updated to database.<br>";
mysql_close($dbconn); // closing connection with database
echo "<right><FORM><INPUT TYPE='BUTTON' VALUE='Next' ONCLICK='history.go(-1)'></FORM></right>";
die;
}
}
?>
