»Chuck PUP Payne« sagte am 2002-04-10 um 10:27:19 -0400 :
> going 9, 8, 5, 10 on the dates. Here is the SQL statement I am using...
That's because your DATE which you've made with DATE_FORMAT is treated
as string. To fix it, I'd write:
> SELECT DATE_FORMAT(DATE, '%M %D, %Y') AS DATE, Title, Lin
Your alias and column name are the same.
Which one do you think is being tested?
Also DATE is a reserved word.
Chuck \"PUP\" Payne wrote:
>Hi again...
>
>When I felt proud because last week I had asked about how to use NOW(), and
>get answer that got me working, but now I have a strange problem
> Hi again...
Hi,
> When I felt proud because last week I had asked about how to
> use NOW(), and
> get answer that got me working, but now I have a strange
> problem. It listing
> dates, but it not listing like it should, when the web page
> is create it
> going 9, 8, 5, 10 on the dates. He