A Database Error Occurred
Error Number: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND h.id = rm.hotel_id AND rm.id = rt.room_id and rt.active='A' and validi' at line 3
select rt.id AS 'rate_id', h.id as hotel_id, rm.hotel_id as rm_hid, rt.room_id as rt_roomid, season, validity, validity_notes, room_type, single, twin,triple, quad, xtrsingle, xtrtwin, xtrtriple, xtrquad from hotel h,room rm,rates rt where h.id = AND h.id = rm.hotel_id AND rm.id = rt.room_id and rt.active='A' and validity>=curdate() and (single!='-' OR single!=0 ) order by field(rm.season,'LEAN SEASON','HIGH SEASON','PEAK SEASON'),rt.id