Please help!
I'm getting the given error at line 18, which is shown below:
I'm sorry to post so much code but I thought it'd be necessary:
/ get delivery details for order /
$dbcnx = myConnect();
$query = "SELECT DELNAME, DELADDRESS1, DELADDRESS2, DELADDRESS3, DELPOSTCODE, NOTES
FROM $table_users
WHERE $table_users.USERNAME = \"$User\"";
$result=mysql_query($query);
if (! $result) printf ("Error: %s<br>", mysql_error ());
$delrow = mysql_fetch_row($result);
/ get products from basket /
$query = "SELECT $table_basket.PROD_ID, $table_basket.CUST_ID, QUANTITY
FROM $table_basket, $table_users
WHERE $table_basket.CUST_ID = $table_users.CUST_ID
AND $table_users.USERNAME = \"$User\"";
$result=mysql_query($query);
if (! $result) printf ("Error: %s<br>", mysql_error ());
<!-- Line 18 --> for ($i = 0; $i < mysql_num_rows ($result); $i++) {
$row = mysql_fetch_row($result);
$cust_id = $row[1]; / needed for del from basket later /
$day = date("Y-m-d");
$query = "INSERT INTO $table_order SET
PROD_ID = $row[0],
QUANTITY = $row[2],
CUST_ID = $row[1],
DAY = $day,
DELNAME = \"$delrow[0]\",
DELADDRESS1 = \"$delrow[1]\",
DELADDRESS2 = \"$delrow[2]\",
DELADDRESS3 = \"$delrow[3]\",
DELPOSTCODE = \"$delrow[4]\",
CARDTYPE = \"$CardType\",
CARDNO = \"$CCardNo\",
EXPIRYYEAR = $ExpiryYear,
EXPIRYMONTH = $ExpiryMonth,
ISSUENO = \"$IssueNumber\",
COMMENTS = \"$Comments\",
STATUS = \"New\"";
$result2=mysql_query($query);
if (! $result2) {printf ("Error: %s<br>", mysql_error ());
}else{
if (mysql_num_rows ($result)>0) {
$query = "DELETE FROM $table_basket WHERE $table_basket.CUST_ID = $cust_id";
$result=mysql_query($query);
if (! $result) printf ("Error: %s<br>", mysql_error ());
};
};
};
The result of $query is:
INSERT INTO c9751198_ORDER SET PROD_ID = 1, QUANTITY = 1, CUST_ID = 1, DAY = 2001-04-28, DELNAME = "Mr John Doe", DELADDRESS1 = "12, Regent Steet,", DELADDRESS2 = "High Village,", DELADDRESS3 = "London.", DELPOSTCODE = "L64 1EP", CARDTYPE = "Visa", CARDNO = "1234567812345678", EXPIRYYEAR = 04, EXPIRYMONTH = 4, ISSUENO = "", COMMENTS = "", STATUS = "New"
Can anyone see what the problem is?
Many thanks,
David.
