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);
check coding
Moderator: General Moderators
Re: check coding
Change
and see if that works. If not: post the error message you're getting.
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)";