 |
|
Code (PHP)
$randnum = rand(00000,99999);
$sql_numcode="select * from tb_order";
$db_queryr=mysql_db_query($db,$sql_numcode);
$result_numcode=mysql_fetch_array($db_queryr);
$num_rows_code=mysql_num_rows($db_queryr);
$run_number = $num_rows_code+1;
$rand_num=sprintf("%05d",$run_number);
$userCus = $_GET[user];
$passCus = $_GET[pass];
$sent_rate = $_GET[sr];
$today = date("d-m-Y");
$sql="select * from member where usermem='$usermem' ";
$result=mysql_db_query($db,$sql);
$rs=mysql_fetch_array($result);
$dateorder = date("$e_date");
$dateime1 = $dateorder;
$date = explode('/', $dateime1);
$newdate = implode('-', array($date[2], $date[1], $date[0]));
for ($n=0;$n<count($sess_idproduct);$n++) {
$sql1= insert("pId,refid,pNum,pPrice,date,id_cus"," '$sess_idproduct[$n]','$rand_num','$sess_num[$n]','$sess_price[$n]','$newdate','$usermem' ","tb_order");
mysql_db_query($db,$sql1);
}
ฟ้องบรรทัดนี้อ่ะค่ะ
Code (PHP)
$sql1= insert("pId,refid,pNum,pPrice,date,id_cus"," '$sess_idproduct[$n]','$rand_num','$sess_num[$n]','$sess_price[$n]','$newdate','$usermem' ","tb_order");
ขึ้น Error ว่า Fatal error: Call to undefined function insert() in C:\AppServ\www\Web\mountainrichall\orderComplete.php on line
ก็คือบรรทัดข้างบนนี้ค่ะ
แก้ยังไงดีคะ
Tag : PHP, MySQL, HTML/CSS, JavaScript
|
|
 |
 |
 |
 |
Date :
2011-02-01 15:35:42 |
By :
idea-soft |
View :
875 |
Reply :
5 |
|
 |
 |
 |
 |
|
|
|
 |