Stupid question. units is no different from item1 at this point.
----- Original Message ----- From: "Jonathan Mangin" <[EMAIL PROTECTED]>
To: <[email protected]> Sent: Tuesday, November 15, 2005 2:36 PM Subject: 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 by the units column _of the current row_ without my selecting it? I thought I'd read about selecting a column before the point of needing to act on it. --Jon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysqlTo unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
