Re: Date and Mysql...

2002-04-10 Thread Alexander Skwar
»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

Re: Date and Mysql...

2002-04-10 Thread Gerald Clark
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

RE: Date and Mysql...

2002-04-10 Thread Christian Pfeiffer
> 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