Re: FN-FORUM mySQL date select

date posted 31st January 2003 13:08

Something along the lines of:

SELECT f1, f2, f3
FROM MyTable
WHERE (START_DATE >= NOW()
AND START_DATE Hi there folks

> I need to select a range of courses from table where START_DATE
> (datetime) is in the next 3 months??

> Any ideas -

> regards

> Andrew Mottershead
> Web Developer
> Mindstream Web Design

> email: [EMAIL REMOVED]
> tel: +44 (0)1743 718262
> fax: +44 (0) 7092 115513
> web: www.mindstream.co.uk

> To help see ... http://www.unitedforpeace.org/

> This e-mail, and any attachment, is confidential. If you have received
> it in error, please delete it from your system, do not use or disclose
> the information in any way, and notify me immediately.



> ========
> Freelancers and Freelance Jobs: http://www.freelancers.net

> Advertise with Freelancers.net http://www.freelancers.net/advert.php

> To unsubscribe please email:
> [EMAIL REMOVED]

> If you have difficulties unsubscribing please email: [EMAIL REMOVED]