Analysis & Solutions wrote:
> On Wed, Jun 12, 2002 at 04:54:30PM +0200, Danny Kruitbosch wrote:
>>Analysis & Solutions wrote:
>>>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.
Thanks! Sometimes the obvious is the last thing you think about....
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php