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`, `d1.colours`, `d1.stitchcount`, `d1.height`, `d1.width`, DATE_FORMAT(`d1.created`, '%d-%m-%Y'), DATE_FORMAT(`d1.amended`, '%d-%m-%Y'), `d2.extdescr` FROM `decheader` AS `d1`, `decextdescr` AS `d2` WHERE (`d1.code` = `d2.code`) AND (`d1.code` = '00042')"; If the code above doesn't work, try it in phpmyadmin and read the error if you get one. hope it helps, Maurits Lawende Mark Colvin wrote: >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, d1.usr, >d1.cusname, d1.colours, d1.stitchcount, d1.height, d1.width, >DATE_FORMAT(d1.created, '%d-%m-%Y'), DATE_FORMAT(d1.amended, '%d-%m-%Y'), >d2.extdescr from decheader as d1, decextdescr as d2 where d1.code = d2.code >and d1.code = '00042' "; > >The problem I am having is with the DATE_FORMAT. Running the above query >returns the following for the 'width' column. > >94.40 DATE_FORMAT(d1.created, '%d-%m-%Y'): NULL DATE_FORMAT(d1.amended, >'%d-%m-%Y'): 03-10-2002 > >The 'width' column should only return 94.40. Why does this query put 3 >columns into one? > > >**************************************************** >This e-mail is intended for the recipient only and >may contain confidential information. If you are >not the intended recipient then you should reply >to the sender and take no further ation based >upon the content of the message. >Internet e-mails are not necessarily secure and >CCM Limited does not accept any responsibility >for changes made to this message. >Although checks have been made to ensure this >message and any attchments are free from viruses >the recipient should ensure that this is the case. >**************************************************** > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
