[SOLVED] Combo Box

[Mewsta]

Hi guys, Im new to PHP so was wondering if anyone can help me, i need to get my php page to display data from a table in a combo box.  Also if there are more than 1 entry the same, then not to duplicate.

 

Can you help?!

[JBS103]

Do you have any code written? If you give us some code we can give you a specific solution to how you should/can do things. The best we can do right is form you a concept and some pseudo code.

 

I'm thinking that you can get all the data from the database into an array. From there, use the array_unique function to get rid of any duplicates. From there, you can run a loop (based on the number of results; using count or something of the like) that will create the HTML needed to form the combo box you want.

[craygo]

<select name=mycomboname>
<?php
$combo = "SELECT DISTINCT(name_field) AS name, id FROM tablename";
$res = mysql_query($combo) or die(mysql_error());
while($r = mysql_fetch_assoc($res)){
  echo "<option value=\"".$r['id']."\">".$r['name']."</option>\n";
}
?>
</select>

 

Substitute the field names and the value of each option to fit your needs

 

Ray

[Mewsta]

Ray, many thanks for this!  I have got this working!