Re: Date
| From: | John Fishworld | Date: | Wed, 22 May 2002 09:23:58 +0000 |
| Subject: | Re: Date | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-19350@lists.php.net to get a copy of this message | ||
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 :-))