Missing column in select??

I thought I'd found a mistake... $sql = (select date(date) as date, time_format(time(date),'%H:%i') as time, units, # I forgot to include this round(sum(item1 * units),2), but all the numbers are correct. Does mysql know to multiply

Re: Missing column in select??

Stupid question. units is no different from item1 at this point. - Original Message - From: Jonathan Mangin [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Tuesday, November 15, 2005 2:36 PM Subject: Missing column in select?? I thought I'd found a mistake... $sql