|
Posted by Chris on 05/25/05 11:42
I'm a PHP newbie and I am stuck!
Please take a look at the following page - http://bororules.cogia.net/ - Notice on the front page I have the latest news. I would
like to format the date of the news item so that it reads 25th May 2005 instead of the 2005-05-25 format that it is in now, this
is where I am stuck.
All the PHP books I have read tell you how to format the date when calling from the timestamp function Date() etc but I cannot
find out how to format the value as it is called from a MySQL database field. I am looking for some guidance as to how to format
that date.
Also does anyone know how I restrict the very top news item (with image) to the latest news item, by date and also have that
particular news item not included on the list below. I have tried to filter using two record sets as follows:
- news filters the list of news items with the filter set up as date <= curdate
- news2 filters the very top news item and is set up as date = curdate.
First off I am not sure if curdate is right for filtering database field (formatted as date) and second if I do the above I assume
I would still get the latest news item in the long list.
Any help is much appreciated.
--
Regards,
Chris.
Navigation:
[Reply to this message]
|