Re: [PHP] DATE_FORMAT (MySQL function)

2002-10-03 Thread Maurits Lawende
Hi, You could try this query... $query = "SELECT `d1.code`, `d1.type`, `d1.descr`, `d1.grouptype`, `d1.cusref`, `d1.stock`, `d1.minstock`, `d1.appmeth` , `d1.supplier`, `d1.suppref`, `d1.leadtime`, `d1.price`, `d1.reorder`, `d1.code1`, `d1.code2`, `d1.notes`, `d1.usr`, `d1.usr`, `d1.cusname`, `d

Re: [PHP] DATE_FORMAT (MySQL function)

2002-10-03 Thread 1LT John W. Holmes
y, October 03, 2002 11:11 AM Subject: [PHP] DATE_FORMAT (MySQL function) > I'm not sure if this is a php or mysql issue but I run the following query > from a php script - > > $query = "select d1.code, d1.type, d1.descr, d1.grouptype, d1.cusref, > d1.stock, d1.minstock, d1.appmet

[PHP] DATE_FORMAT (MySQL function)

2002-10-03 Thread Mark Colvin
I'm not sure if this is a php or mysql issue but I run the following query from a php script - $query = "select d1.code, d1.type, d1.descr, d1.grouptype, d1.cusref, d1.stock, d1.minstock, d1.appmeth, d1.supplier, d1.suppref, d1.leadtime, d1.price, d1.reorder, d1.code1, d1.code2, d1.notes, d1.usr,