Sorry yes its MySQL yes it was the missing comma causing the problem (thanks) but now I get You have an error in your SQL syntax near 'LIMIT 0, 30' at line 1
SELECT DISTINCT ...... WHERE (t_city.t_city_id_city = t_citystate.t_citystate_id_city) AND (t_citystate.t_citystate_id_state = t_state.t_state_id_state) AND (t_city.t_city_id_city = j_niederlassung.t_niederlassung_city_id) AND (j_niederlassung.t_niederlassung_firm_id = j_firm.t_firm_id) AND (j_niederlassung.t_niederlassung_id = j_stellenniederlassung.t_stellenniederlassung_id_niederlassung) AND (j_stellenniederlassung.t_stellenniederlassung_id_stellen = j_stellen.t_stellen_id) AND (j_stellen.t_stellen_id = j_stellenbranchen.t_stellenbranchen_id_stellen) AND (j_stellen.t_stellen_id = j_stellentype.t_stellentype_id_stellen) AND (j_stellen.t_stellen_id = j_stellenberufe.t_stellenberufe_id_stellen) AND (j_stellenberufe.t_stellenberufe_id_berufe = j_berufe.t_berufe_id_berufe) AND (j_stellenbranchen.t_stellenbranchen_id_branchen = j_branchen.t_branchen_id_branchen) AND (j_stellentype.t_stellentype_id_type = j_type.t_type_id) AND (t_stellen_who != 3) AND ((t_stellen_wanted = 0) or (t_stellen_wanted = 2) or (t_stellen_wanted = 4)) AND ((DATE_SUB(NOW(), INTERVAL 2 day) < j.stellen.t_stellen_date) LIMIT 0, 30 It works fine without the Date part. Okay no more exclamation marks :-)) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php