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 F
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(F
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 t
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 va
print "".$Row[2]."";
print "";
}
?>
-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'
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 FIELD1
6 matches
Mail list logo
