"distinct" sql using php and postgres

Anon

I would LOVE if someone could tell me why the "distinct" sql command is not retreaving data only once like it should in this script. this script selects the "level" entered for each entry out of the "scholarship" table located in the "funds" database. i thought that perhaps i needed to specify the field "level" rather than use the but that created an error and didnt allow the select box to be populated by the db. then i tried to use the $option instead of the but that basically came out with the same error. then i tried changing the spacing and THAT didnt work at all. if someone can help or even has a self populating script i could use - that would be so excellent, thanks for any help.

<?php
$table="scholarship"; // name of the table
$limit="20"; // limit # of records in select box
$orderBy="schol_id"; // Usually a column name
$conn = pg_connect("","","","","funds");
if
(!$conn)
{echo "Could not make a connection";exit;}
$sql = "SELECT DISTINCT * FROM $table order by $orderBy;";
$select_box = pg_Exec($conn, $sql);
$numrecords = pg_NumRows($select_box);
echo "<select name=select>";
//pre selected option
echo"<option value=none>select type</option>";
//loop through database to populate select box
for ($j=0; $j < $numrecords; $j++) {
$value = pg_result($select_box, $j, "level"); //column name for the value of the checkbox
$option = pg_result($select_box, $j, "level"); // select option column name
echo"<option value=$value>$option</option>";
}
echo"</select>";

?>

smarlowe

I'm not sure you're getting the gist of distinct here.

Imagine I had a table like this:

id fname lname age

1 Scott Jones 23
2 Stan Smith 25
3 Susan Jones 23
4 Scott Smith 26

select distinct fname from table

Scott
Stan
Susan

select distinct fname, lname from table:

Scott Jones
Stan Smith
Susan Jones
Scott Smith

select distinct lname, age from table

Jones 23
Smith 25
Smith 26

Distinct works on a SET, not the individual rows. So, whatever you ask for, AS A SET, is tested for distinctness, not the individual parts.