Populating dropdown box.

[todayme]

I have been looking around the internet for an example of what I need to do but cant find anything was wondering if someone here might be able to help.

 

What I need to do is to connect to a mysql db select a table and then a field from that table and put all the contents of that field into a dropdown box.

 

Anyone got any sugestions?

 

 

[Yesideez]

Something like this:

<select name="names"><?php
  $query=mysql_query("SELECT name FROM table ORDER BY name ASC");
  while ($fetch=mysql_fetch_assoc($query)) {
    echo '<option value="'.$fetch['name'].'">'.$fetch['name'].'</option>';
  }?></select>

[WebDevon]

this is how I do it:

 

<select size="1" name="txtRecall" style="font-family: Arial Unicode MS; font-size: 10px">
						<?php
						mysql_select_db("database_name") or die(mysql_error());
						$result = mysql_query("SELECT * FROM tblName")
			or die(mysql_error());
						while ($row = mysql_fetch_array($result)) {
							$Item_ID = $row['ID'];
							$Name = $row['Name'];
							?>
							<option value="<?=Item_ID?>"><?=$Name?></option>
						<? } ?>
						</select>

[Yesideez]

Well, does that work for you or are you having problems with it?

[WebDevon]

dont know who your referencing but mine works just fine.

[Yesideez]

hahahaha sorry I got very confused there

 

Ignore me, having a thicko moment

[todayme]

Sorry just got some visitors, back to again just about to try it............ I am in the midle of designing the database relationships.  Will update you soon as I have tried it.

 

Buy the way your help is really appreciated.

[todayme]

I have done this cond with your example but have a problem with it... any comments on what the problem may be? 

 

<?

 

$dbhost = "localhost";

$dbuser = "admin_sex";

$dbpass = "sex";

$dbname = "admin_sex";

 

 

 

$db = mysql_pconnect($dbhost,$dbuser,$dbpass);

mysql_select_db($dbname) or die(mysql_error());

 

 

<select name="names">

  $query=mysql_query("SELECT name FROM _Industries");

  while ($fetch=mysql_fetch_assoc($query)) {

    echo '<option value="'.$fetch['Industry'].'">'.$fetch['Industry'].'</option>';

  }</select>

 

 

 

 

?>

[todayme]

Okay I am trying this now no errors but also no data in the drop down box ha ha......any ideas lol

 

<?

 

$dbhost = "localhost";

$dbuser = "admin_sex";

$dbpass = "sex";

$dbname = "admin_sex";

 

 

 

$db = mysql_pconnect($dbhost,$dbuser,$dbpass);

mysql_select_db($dbname) or die(mysql_error());

 

?>

 

 

<select name="names"><?php

 

  $query=mysql_query("SELECT name FROM _Industries");

  while ($fetch=mysql_fetch_assoc($query)) {

    echo '<option value="'.$fetch['Industry'].'">'.$fetch['Industry'].'</option>';

  }?></select>

 

 

 

 

 

[todayme]

I worked it out, lol eye for detail today isnt good.  Probabley helps when you get the syntax I learned in VB ha ha Thanks guys really appreciated.