01.<?php
02.
03.$colname_Recordset5 = "-1";
04.if (isset($_GET['cus_id'])) {
05.$colname_Recordset5 = $_GET['cus_id'];
06.}
07.mysql_select_db($database_ConnectSW, $ConnectSW);
08.$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"));
09.$objQuery7 = mysql_query($strSQL7, $ConnectSW);
10.$totalRows_Recordset5 = mysql_num_rows($objQuery7);
11.if ($totalRows_Recordset5 > 0) {
12. }else{
13. $msg1="ไม่พบข้อมูลการจอง";
14. }
15.
16.?>
