RE: [PHP] mysql select and date functions

2003-02-18 Thread John W. Holmes
> Change your query: > selectdayofmonth(Posted) as DOM_Posted, > month(Posted) as M_Posted, > year(Posted)as Y_Posted, > hour(Posted) as HH_Posted, > minute(Posted) as MM_Posted, > Name, > Prayer > from pray

Re: [PHP] mysql select and date functions

2003-02-18 Thread Sunfire
tnx it worked just like i wanted it to... - Original Message - From: "Barajas, Arturo" <[EMAIL PROTECTED]> To: "'Sunfire'" <[EMAIL PROTECTED]> Sent: Tuesday, February 18, 2003 7:59 PM Subject: RE: [PHP] mysql select and date functions > Ha

RE: [PHP] mysql select and date functions

2003-02-18 Thread Bryan Lipscy
Change your query: select dayofmonth(Posted) as DOM_Posted, month(Posted) as M_Posted, year(Posted)as Y_Posted, hour(Posted) as HH_Posted, minute(Posted) as MM_Posted, Name, Prayer from prayer T