I've two queries on the same table. They have the following structure:
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
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.
How do I do this??
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php