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

http://www.lcounty.com/boe/2000_11_candidates.php thanks a million --------------------- 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: Asendorf, John [mailto:JAsendorf@lcounty.com] > Sent: Friday, September 01, 2000 4:28 PM > To: php-windows@lists.php.net > Subject: 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 > > > > -- > 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 >