"%D %M
%Y") as
> > evdt FROM notices WHERE eventdate >= $todaysdate ORDER BY
> > eventdate";
> >
> >
> >
> >
> > Mike
> > - Original Message -
> > From: "Alex Francis" <[EMAIL PROTECTED]&
> $query = "SELECT id, eventheading, DATE_FORMAT(eventdate, "%D %M %Y") as
> evdt FROM notices WHERE eventdate >= $todaysdate ORDER BY
> eventdate";
>
>
>
>
> Mike
> ----- Original Message -
> From: "Alex Francis" <[EMAIL PROTECTE
Mike
- Original Message -
From: "Alex Francis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 17, 2002 5:26 PM
Subject: Re: [PHP-DB] Dates in MYSQL
> Tried the following as suggested - Still no dates showing
>
> $query = ' SELECT id, even
Tried the following as suggested - Still no dates showing
$query = ' SELECT id, eventheading, DATE_FORMAT("eventdate", "%D %M %Y")as
"evdt" FROM notices WHERE TO_DAYS(eventdate) >= TO_DAYS(now()) order by
eventdate';
$result=mysql_db_query($dbname, $query, $link);
if (!$result) { echo( mysql_e
Hi Alex,
> Got my select statement to work as follows:
> $query = ' SELECT * FROM notices WHERE TO_DAYS(eventdate) >=
TO_DAYS(now())
> order by eventdate';
=well done!
However the TO-DAYS calls do seem a bit OTT.
Please post the schema for tbl:notices - specifically the datatype for
eventdate.
Hi Alex Francis,
>
SELECT From the database WHERE date >= todays date.
^ somethink like now() or date()
an other method you put the date in a variable that you get by the
datecommand and make
SELECT From WHERE date >= datevar (variable with current da
