RE: FN-FORUM mySQL date select

date posted 31st January 2003 13:50

Thanks Pete and James - sorted now...

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.



> -----Original Message-----
> From: [EMAIL REMOVED]
> [EMAIL REMOVED] On Behalf Of Pete Croft
> Sent: 31 January 2003 13:05
> To: Andrew Mottershead
> Subject: Re: FN-FORUM mySQL date select
>
>
> Something along the lines of:
>
> SELECT f1, f2, f3
> FROM MyTable
> WHERE (START_DATE >= NOW()
> AND START_DATE
>
> --
> Pete
>
> ==== Original Message:
>
> > 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 morning> 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]
>
> ========
> Freelancers and Freelance Jobs: http://www.freelancers.net
>
> Advertise with Freelancers.net http://www.freelancers.net/advert.php
>
> To unsubscribe please email:
> [EMAIL REMOVED] 20freelancers
>
>
> If you have difficulties unsubscribing please
> email: [EMAIL REMOVED]
>
>
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.443 / Virus Database: 248 - Release Date: 10/01/2003
>
>