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
ata_query, $dbh);
*
On Wed, 21 Sep 2005 16:11:32 -0400, Bastien Koert <[EMAIL PROTECTED]>
wrote:
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] Repe
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
I have a table created from two mysql tables which shows all Members of
Congress with related data. The Representative's name is pulled from one
sql table and the data from another sql table. When the php table comes
up on the web page, the name of the Representative for Maryland's 2nd
di