Results 1 to 8 of 8
Threaded View
-
04-22-2004, 05:14 PM #1Junior Guru
- Join Date
- Aug 2003
- Location
- Walsall - UK
- Posts
- 177
PHP+mySQL - whats wrong with this query?
I have a query and im getting errors with it...
PHP Code:$query="SELECT b.*, c.* FROM tod_company_information c INNER JOIN tod_bookings_archive b ON c.company_id = b.company_id $filter_string WHERE b.date_fitted < DATE_SUB(now(),INTERVAL 1 YEAR)ORDER BY b.date_in ASC";
any ideas
Thanks in advance
crE<<< Please see Forum Guidelines for signature setup. >>>