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
