SELECT DISTINCT-- Sort Order

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
39corp
Forum Newbie
Posts: 1
Joined: Tue Jan 27, 2009 8:13 am

SELECT DISTINCT-- Sort Order

Post by 39corp »

Hi there Guys

I have a small problem with the sort-order when using "SELECT DISTINCT" for a search script. This is what I have:

<select name="type" class="textField" id="select2">
<?php
if ($type == ""){
print " <option value=\"0\" selected>All Types</option>";
}else{
print " <option value=\"0\" >All Types</option>";
}
$res = dbsql("SELECT DISTINCT (type) FROM carsz");
while (($row = dbfetch($res)) != NULL) {
$res2 = dbsql("SELECT * FROM type WHERE id = '$row[type]' ORDER BY type ASC");
$row2 = dbfetch($res2);
if ($type == $row2[id]){
print "<option value=\"".$row2[id]."\" selected>".$row2[type]."</option>\n ";
}else{
print "<option value=\"".$row2[id]."\">".$row2[type]."</option>\n ";
}
}
?>
</select>


Basically there are 2 tables:
1) table with listings
2) table with types

So the "type" in table 1 is just an ID that refer back to table 2. But when I use the script the sort order of the different types are not alphabetical.

PLEASE HELP
Andy
Post Reply