»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
(one should not mess up strg and shift :-/)
> 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 c
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
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. 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. Here is the SQL statement I
