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

Reply via email to