Re: cookies multiple pages
| From: | John Fishworld | Date: | Wed, 03 Jul 2002 15:25:11 +0000 |
| Subject: | Re: cookies multiple pages | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-20298@lists.php.net to get a copy of this message | ||
Banging my head against a wall with this !
Hope someone can help !
Using MySQL
Trying to list cities with events for that month
I've correctly (i think) formatted my date to a datetime style for MySQL
$month is there chosen one
$tosearch = date("Y-$month-d 00:00:00");
And then this is my inquiry -(although this just would be 60 days in advance
but it doesn't work)
And what I really want is just for that month ?
SO if its already 20th of the month it only looks a the next 11 days
SELECT distinct t_city_name,t_city_id_city, t_event_date
FROM t_city,t_zipcodecity,t_location,t_event
WHERE (t_city_id_city = t_zipcodecity_id_city)
AND (t_zipcodecity_zipcode = t_location_zipcode )
AND (t_location_sex = 2)
AND (t_location_id_location = t_event_id_location)
AND (t_event_date = (DATE_ADD('2002-07-03 00:00:00', INTERVAL 60 day)) )
ORDER by t_city_name
Can anyone help please