Alex,
> enterdate text NOT NULL
> eventdate text NOT NULL
First, I think I would change the above to a date or datetime or one of the
other date & time fields used by mysql instead of text fields.
Second I don't think you really need to use TO DAYS and now. This is what I
do.
use php date function to get the current date,
$todaysdate = date("Ymd");
then do the query,
$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 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, 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_error()); }
> else
>
>
> while ($row = mysql_fetch_array($result))
>
>
> $entername = $row[entername];
> $eventdate = $row[evdt];
> $eventheading = $row[eventheading];
> $id = $row[id];
>
> Database table "notices" as follows
> id int NULL autoincrement
> entername text NOT NULL
> enterdate text NOT NULL
> eventdate text NOT NULL
> eventheading text NOT NULL
> eventbody text NOT NULL
>
>
>
>
> --
> Alex Francis
> Cameron Design
> 35, Drumillan Hill
> Greenock PA16 0XD
>
> Tel 01475 798106
> [EMAIL PROTECTED]
> http://www.camerondesign.co.uk
>
> This message is sent in confidence for the addressee only. It may contain
> legally privileged information.
> Unauthorised recipients are requested to preserve this confidentiality and
> to advise the sender
> immediately of any error in transmission.
> Dl Neil <[EMAIL PROTECTED]> wrote in message
> 0b8401c1e62e$03072ad0$0600a8c0@jrbrown">news:0b8401c1e62e$03072ad0$0600a8c0@jrbrown...
> > 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.
> >
> > > Now trying to get the date more user friendly and tried:
> > >
> > > $query = ' SELECT id, eventheading, DATE_FORMAT("eventdate", "%D %M
> > %Y")FROM
> > > notices WHERE TO_DAYS(eventdate) >= TO_DAYS(now()) order by
> > eventdate';
> > ...
> > > When I echo ($eventdate) I get nothing. Not even an error.
> >
> >
> > The problem is that
> >
> > $eventdate = "$row[eventdate]";
> >
> > (which doesn't need the " around the whole of the RHS (some would put
> > them around eventdate), BTW)
> > doesn't tie up with:
> >
> > DATE_FORMAT("eventdate", "%D %M %Y")
> >
> > Recommend you change them to:
> >
> > DATE_FORMAT("eventdate", "%D %M %Y") AS evdt
> > and
> > $eventdate = $row[evdt];
> >
> > See how the SQL and PHP tie together?
> > Now you need to reconsider the other $row[] assignments.
> >
> > =Keep it coming!
> > =dn
> >
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
