Page 1 of 1

check coding

Posted: Wed May 12, 2004 1:43 am
by enefahchen
can check for me, whether the following coding correct??

$sql = "insert into orderlist (SCID ,productID ,userID ,SCDate ,price ,quantity ,SCPrice)
values ('NULL','$proI[$id]','$username','$todate',$price,$quantity,$total)";
$result = mysql_query($sql, $db);

Re: check coding

Posted: Wed May 12, 2004 3:03 am
by patrikG
Change

Code: Select all

$sql = "insert into orderlist (SCID ,productID ,userID ,SCDate ,price ,quantity ,SCPrice) 
values ('NULL','$proI[$id]','$username','$todate',$price,$quantity,$total)";

Code: Select all

$sql = "insert into orderlist (SCID ,productID ,userID ,SCDate ,price ,quantity ,SCPrice) 
values ('NULL','{$proI[$id]}','$username','$todate',$price,$quantity,$total)";
and see if that works. If not: post the error message you're getting.