 |
|
ช่วยทีครับ มันรัน แล้วขึ้นแบบนี้ครับ
คือตอนแรก inner join tbl car ได้ครับ พอผมใส่อีก join อีก tbl transfer แล้วขึ้นแบบนี้ครับ ช่วยทีครับ
-------------------------------------------------------------
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\carforsale\Templates\Paymentbank.dwt.php on line 558
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\carforsale\Templates\Paymentbank.dwt.php on line 582
-------------------------------------------------------------
Code (PHP)
<?php
$colname_Recordset5 = "-1";
if (isset($_GET['cus_id'])) {
$colname_Recordset5 = $_GET['cus_id'];
}
mysql_select_db($database_ConnectSW, $ConnectSW);
$strSQL7 = sprintf("SELECT reservations.id_re,reservations.cus_id,reservations.car_id,reservations.status_re,car.id_car,car.brand_car,car.gene_car,car.color_car,car.year_car,transfer.re_tr,transfer.status_tr FROM reservations INNER JOIN car ON car.id_car = reservations.car_id INNER JOIN transfer ON transfer.re_tr = reservations.id_re Where cus_id = %s AND status_re = 'ตรวจสอบ'", GetSQLValueString($colname_Recordset5, "text"));
$objQuery7 = mysql_query($strSQL7, $ConnectSW);
$totalRows_Recordset5 = mysql_num_rows($objQuery7);
if ($totalRows_Recordset5 > 0) {
}else{
$msg1="ไม่พบข้อมูลการจอง";
}
?>
Tag : PHP, MySQL
|
|
|
 |
 |
 |
 |
| Date :
2017-02-23 18:15:46 |
By :
tomzone2 |
View :
673 |
Reply :
4 |
|
 |
 |
 |
 |
|
|
|
|
 |
