 |
|
อันนี้โคดครับ
Code (PHP)
$SQL = "SELECT distinct
`member`.`name`,
`member`.`sex`,
`member`.`organ`,
`member`.`fax`,
`member`.`tel`,
`member`.`email`,
`booking`.`b_id`,
`booking`.`appdate`,
`booking`.`detail`,
`booking`.`organ`,
`booking`.`sdate`,
`booking`.`edate`,
`booking`.`stime`,
`booking`.`etime`,
`booking`.`room`,
`booking`.`status`
FROM
`booking`
INNER JOIN `member` ON `booking`.`organ` = `member`.`organ` WHERE `booking`.`status`='0' AND `booking`.`organ` LIKE '%$org%'";
Tag : PHP
|
|
|
 |
 |
 |
 |
| Date :
2013-05-08 15:05:23 |
By :
white31969 |
View :
5743 |
Reply :
9 |
|
 |
 |
 |
 |
|
|
|
|
 |
