I still can't see what's wrong with this code query_again.php. The error message says that there's parse error on line 36. Help me check what's wrong please.
query_again.php
<html>
<?include("dbConnect.php"); ?>
<body>
<?php
// Check if $id is set and not empty
if ($id&&strlen($id)>0) {
//run query and check for validity
$result = mysql_query("SELECT * FROM customer WHERE CustID =$id",$db)
or die("wrong syntax in query! ".mysql_error() );
if(mysql_num_rows($result)==1){
$myrow = mysql_fetch_array($result);
printf("Customer ID: %s\n<br>", $myrow["CustID"]);
printf("Company: %s\n<br>", $myrow["Company"]);
printf("Business Nature: %s\n<br>", $myrow["Business_nature"]);
printf("Contact person: %s\n<br>", $myrow["Contact_person"]);
printf("position: %s\n<br>", $myrow["Position"]);
printf("address: %s\n<br>", $myrow["Address"]);
printf("tel: %s\n<br>", $myrow["Tel"]);
printf("fax: %s\n<br>", $myrow["Fax"]);
printf("handphone: %s\n<br>", $myrow["Handphone"]);
printf("e-mail: %s\n<br>", $myrow["E-mail"]);
printf("website: %s\n<br>", $myrow["Website"]);
printf("birthday: %s\n<br>", $myrow["Birthday"]);
printf("remarks: %s\n<br>", $myrow["Remarks"]);
}
else {
echo "no record";
}
else {
echo "no id submitted!";
}
?>
</body>
</html>
P.s.I have linked my client.html to query_again.php, still not working.
