Re: Missing column in select??

[Jonathan Mangin]

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 = "(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]



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]