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 >> >>Now I want to print a table that prints the values of FIELD1, TOTAL and >> SUB. >> >>Query 1 returns more rows as query 2. Field1 is the same in both queries >>so I should be able to 'link' the results of both queries together. >> > > I'm wondering exactly what you're trying to do. It may be possible to do > in one well crafted query. Why limit the second query only to items where > Field2 = 1? What's in FIELD1 and FIELD2? > > Also, I assume you want each row of your HTML table to have the FIELD1, > TOTAL and SUB fields in them, right? > > --Dan > >
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. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php