$sql = "SELECT tr.*,p.*, c.*, bg.*, lm.* ,y.*
FROM training tr
LEFT JOIN persons p ON tr.person_id = p.person_id
LEFT JOIN tbl_learn_catagory c ON tr.cat_learn_id = c.cat_learn_id
LEFT JOIN tbl_budget bg ON bg.budget_id = tr.budget_id
LEFT JOIN tbl_learn_money lm ON lm.money_id = tr.money_id
LEFT JOIN tbl_year y ON y.year_id = tr.year_id
WHERE (tr.training_date_start between '".$_GET["date_start"]."' ) AND '".$_GET["date_end"]."')
ORDER BY tr.training_date_start ASC";
------------------------------------------------------------
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in E:\AppServ\www\psu\input_person_training_view.php on line 193
----------------------- [ บันทัด 193 ] ---------------
192 : $result = mysql_query($sql);
193 : $num_record = mysql_num_rows($result);
Tag : PHP, MySQL
Date :
2014-10-31 07:25:15
By :
hasanlebaesa
View :
627
Reply :
1
No. 1
Guest
มันต้องเป็น แบบนี้หรือปล่าวครับ
Code (PHP)
WHERE (tr.training_date_start between '".$_GET["date_start"]."' AND '".$_GET["date_end"]."')
Load balance : Server 04
