"SELECT DISTINCT" -- Sort Order

[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

[cooldude832]

Add ORDER BY to the query at the end

[39corp]

Your php Freaks are really fast thanks you are great!!!

 

Could you indicate where at the end to put "Order By" please or simply modify my sample code for me I really would appreciate it. Sorry but I'm new to PHP and rely on guys like you for help. Really appreciate this!!!

 

Andy

[bluesoul]

Your php Freaks are really fast thanks you are great!!!

 

Could you indicate where at the end to put "Order By" please or simply modify my sample code for me I really would appreciate it. Sorry but I'm new to PHP and rely on guys like you for help. Really appreciate this!!!

 

Andy

 

ORDER BY should be the last statement in your query, after any WHEREs.