Re: [PHP] Compare 2 resultsets of db-query

2002-06-12 Thread Danny Kruitbosch
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

Re: [PHP] Compare 2 resultsets of db-query

2002-06-12 Thread Analysis Solutions
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

Re: [PHP] Compare 2 resultsets of db-query

2002-06-12 Thread Danny Kruitbosch
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

[PHP] Compare 2 resultsets of db-query

2002-06-10 Thread Danny Kruitbosch
Hi, 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

RE: [PHP] Compare 2 resultsets of db-query

2002-06-10 Thread Lazor, Ed
; print td.$Row[2]./td; print /tr; } ? /table -Original Message- From: Danny Kruitbosch [mailto:[EMAIL PROTECTED]] Sent: Monday, June 10, 2002 1:09 PM To: [EMAIL PROTECTED] Subject: [PHP] Compare 2 resultsets of db-query Hi, I've two queries on the same

Re: [PHP] Compare 2 resultsets of db-query

2002-06-10 Thread Analysis Solutions
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