Error in sql statement:
SELECT p.*, dateDiff(p.date, current_timeStamp) day_left, h.hname, ho.holiday_name, DATE_FORMAT(p.date, '%d %b %Y') tour_date, d.img, d.dname, d.durl, d.star, d.message, d.did FROM price_list p LEFT JOIN hotels h ON p.hotel=h.hid LEFT JOIN holiday ho ON p.holiday=ho.hid LEFT JOIN destinations d ON p.destination=d.did WHERE p.pstatus='1' AND p.status='1' AND p.date > DATE_ADD( curdate() , INTERVAL +6 DAY ) GROUP BY d.did ORDER BY date,duration ASC LIMIT 6
Table 'solitair_newsite1.destinations' doesn't exist