Posted by kenoli on 11/15/05 15:42

I an using only one field to store the date info, which is a date type.
Here is the format, as exported from the actual table:

`date` date NOT NULL default '0000-00-00'

Here is the query (The two fields accessed are date, summary):

$query = "SELECT date_format(date, '%c.%e.%Y') as date, summary
FROM tbl_news_stories ORDER BY date DESC";
$result = mysql_query ($query);

while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {

echo "<p>{$row['date']} - {$row['summary']}</p>";

Check out the output at:

http://www.communityassemblies.org/index_nan.php

Look in the scroll box under "NAN News"

In sending this, I am noticing that there are some other anomalies.
The two records before the offending "10' record are out of order also.

Thanks,

--Kenoli

• Next in forum: Re: ORDER BY order of months
• Prev in forum: Re: Refresh Problems
• Thread view: Re: ORDER BY order of months

[Reply to this message]