Re: [PHP] Re: mysql timestamp and php date

2002-09-30 Thread Bryan Koschmann - GKT
This is what I am using here: $db = DB::connect("mysql://$username:$password@$hostName/$databaseName"); if (DB::iserror($db)) die($db->getMessage()); $sql = "SELECT idnum, title, DATE_FORMAT(date, '%W, %M %D \@ %l:%i%p'), news FROM newslist ORDER BY idnum DESC"; $query = $db->query($sq

Re: [PHP] Re: mysql timestamp and php date

2002-09-30 Thread Jason Young
No problem! Refresh MY memory here.. I noticed you didn't return the DATE_FORMAT column "AS " .. is that working okay? I seemed to think that it returned a long unwieldy column name.. maybe things are good.. let me know :-D --Jason Bryan Koschmann - Gkt wrote: > Hi Jason, > > I had come ac

Re: [PHP] Re: mysql timestamp and php date

2002-09-30 Thread Bryan Koschmann - GKT
Hi Jason, I had come across this earlier, and while I can get it to return perfectly, I was more looking for something that I could do without having to pull 2 queries. Err, well wait, I wouldn't have to would I? I have 4 columns: idnum, title, date, news I was just doing a select * from newlis