39corp Posted January 27, 2009 Share Posted January 27, 2009 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 Quote Link to comment Share on other sites More sharing options...
cooldude832 Posted January 27, 2009 Share Posted January 27, 2009 Add ORDER BY to the query at the end Quote Link to comment Share on other sites More sharing options...
39corp Posted January 27, 2009 Author Share Posted January 27, 2009 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 Quote Link to comment Share on other sites More sharing options...
bluesoul Posted January 27, 2009 Share Posted January 27, 2009 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.