Analysis & Solutions wrote: > On Wed, Jun 12, 2002 at 04:54:30PM +0200, Danny Kruitbosch wrote: > >>Analysis & Solutions wrote: >> >>>Hey Danny: >>> >>>On Mon, Jun 10, 2002 at 10:09:12PM +0200, Danny Kruitbosch wrote: >>> >>> >>>>Query1: SELECT FIELD1, COUNT(FIELD2) AS TOTAL from TABLE GROUP BY FIELD1 >>>>Query2: SELECT FIELD1, COUNT(FIELD2) AS SUB from TABLE WHERE FIELD2=1 >>>>GROUP BY FIELD1 >>>> >>FIELD 1 contains IP address pool names (not unique), field2 the status >>(0 free, 1 leased). So what I try to do is get an overview of the total >>number of IP adresses in a pool and the number of leased addresses. >>There's a fourth field that contains the actual address. >> > > 0 and 1 in FIELD2? That makes this a piece of cake! All you need is one > query. In Query1, do a SUM(FIELD2) rather than COUNT(FIELD2). Forget > about Query2. > > --Dan > >
Thanks! Sometimes the obvious is the last thing you think about.... Danny -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
