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

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