RE: [PHP-WIN] OK, have to have this done by 5... SQL help please

Thanks all! That was what I was looking for! John --------------------- John Asendorf - jasendorf@lcounty.com Web Applications Developer http://www.lcounty.com - CHECK OUT THE NEW LOOK! Licking County, Ohio, USA 740-349-3631 > -----Original Message----- > From: Andrian Pervazov [mailto:apervazov@aspen-marketing.com] > Sent: Friday, September 01, 2000 4:22 PM > To: Asendorf, John > Cc: php-windows@lists.php.net > Subject: Re: [PHP-WIN] OK, have to have this done by 5... SQL help > please > > > SELECT DISTINCT might help you. > > Andrian > > "Asendorf, John" wrote: > > > > I've spent the last 10 minutes hunting for an SQL command > which will return > > all of the unique entries in a column. > > > > I have a table with a list of names and the district in > which they are > > running... I want to make a group of tables which are separate by > > district... I've got all the code I need, BUT, I can't > figure out how to > > get all the unique districts out of the table - fourth > line down - > > thanks in advance > > > > John > > > > <?PHP > > // create SQL statement for district > > $districtSQL = "SELECT firstname,district,office,term,party > > FROM 2000_11_candidates > > WHERE district"; // WHAT GOES HERE?!?!?! > > > > // prepare SQL statement > > $district_result = odbc_prepare($connection,$districtSQL); > > > > // execute SQL statement and get results > > odbc_execute($district_result); > > > > //write the table > > > > while (odbc_fetch_row($district_result)) { > > $district = odbc_result($district_result,"district"); > > > > echo "<table border=\"1\" > > > > cellpadding=\"5\"><caption>${district}</caption><thead>"; > > echo > > > > "<tr><th>Office</th><th>Name</th><th>Address</th><th>City</th> > <th>Zip</th>"; > > echo > > "<th>Term</th><th>Party*</th></tr></thead><tbody>"; > > > > // create SQL statement for candidates in that district > > $candidatesSQL = "SELECT > > firstname,office,address,city,zip,term,party > > FROM 2000_11_candidates > > WHERE district = $district > > GROUP BY office"; > > > > // prepare SQL statement > > $cand_result = odbc_prepare($connection,$candidatesSQL); > > > > // execute SQL statement and get results > > odbc_execute($cand_result); > > > > while (odbc_fetch_row($cand_result)) { > > > > $name = odbc_result($cand_result,"firstname"); > > $office = odbc_result($cand_result,"office"); > > $address = odbc_result($cand_result,"address"); > > $city = odbc_result($cand_result,"city"); > > $zip = odbc_result($cand_result,"zip"); > > $term = odbc_result($cand_result,"term"); > > $party = odbc_result($cand_result,"party"); > > > > echo "<tr><td>${name}</td>\n"; > > echo "<td>${office}</td>\n"; > > echo "<td>${address}</td>\n"; > > echo "<td>${city}</td>\n"; > > echo "<td>${zip}</td>\n"; > > echo "<td>${term}</td>\n"; > > echo "<td>${party}</td></tr>\n"; > > } > > > > echo "</tbody></table>\n<P>&nbsp;</P>\n\n"; > > > > } > > > > ?> > > > > -- > > PHP Windows Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > > For additional commands, e-mail: php-windows-help@lists.php.net > > To contact the list administrators, e-mail: > php-list-admin@lists.php.net > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > For additional commands, e-mail: php-windows-help@lists.php.net > To contact the list administrators, e-mail: > php-list-admin@lists.php.net >