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/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
