drop menu

[networkthis]

I am trying to populate a drop menu from mysql...I would like to not have locations that have already displayed to be redisplayed.  There are a lot of duplicated locations.  Each location only needs to be displayed one time in the menu.  I have a seperate search function written to display mysql results based on selected location.

 

Any ideas or suggestions would be great!  Thanks in advance

<?php
$query="SELECT location FROM jb";


$result = mysql_query ($query);echo "<select name=category value=''></option>";

while($nt=mysql_fetch_array($result)){

echo "<option value=$nt[location]>$nt[location]</option>";


}echo "</select>";

?> 

[Jeremysr]

It sounds like changing your MySQL query to only select "distinct" locations is what you want:

 

$query="SELECT DISTINCT location FROM jb";

 

This will not give you any duplicate location fields.

[networkthis]

awesome thank you so much!!!  Now that brings up another question... where is there a good source for all of the different things you can do with mysql querys and some examples for the mysql querys???

 

Also how difficult is it to sort these alphabetically?     

[networkthis]

OK I actually knew the answer for the sorting, just forgot!!!  Is this the most efficient way though?

 

<?php
$query="SELECT DISTINCT country FROM jb_jobs ORDER BY country ASC"; 
?>

[Jeremysr]

awesome thank you so much!!!  Now that brings up another question... where is there a good source for all of the different things you can do with mysql querys and some examples for the mysql querys???

 

Google it: http://google.com/search?q=mysql+tutorials

 

You'll find all sorts of tutorials and documentation for MySQL.

 

OK I actually knew the answer for the sorting, just forgot!!!  Is this the most efficient way though?

 

Yep, it is.