To: "php-db@lists.php.net"
Subject: Re: [PHP-DB] Repetitive Result
Date: Wed, 21 Sep 2005 16:17:53 -0400
Here's the query (actually pulled from 3 sql tables; no joins):
"select
109fh4.rep,
veteransdata04.state,
veteransdata04.cd,
109fh4.party,
1091vote224.vote1091224,
vetera
um, that is a join, just uses the older syntax.
try selecting with the distinct clause
select
distinct(109fh4.rep),
veteransdata04.state
bastien
From: [EMAIL PROTECTED]
To: "php-db@lists.php.net"
Subject: Re: [PHP-DB] Repetitive Result
Date: Wed, 21 Sep 2005 16:17:53 -0400
Here's the query (actually pulled from 3 sql tables; no joins):
"select
109fh4.rep,
veteransdata04.state,
veteransdata04.cd,
109fh4.party,
1091vote224.vote1091224,
veteransdata04.vetpop,
veteransdata04.totalexpend*1000,
veteransdata04.totalpatients,
veteransdata04.medexpend*1000,
veteransdata04.
depends on your query, some joins might make for duplicate results...show
your code
bastien
From: [EMAIL PROTECTED]
To: "php-db@lists.php.net"
Subject: [PHP-DB] Repetitive Result
Date: Wed, 21 Sep 2005 16:02:48 -0400
I have a table created from two mysql tables which shows all Members of
