drop down list

[jagguy]

Hi,

I want to have a drop down list on a form full of data from a mysql database. How do i set this up with php or is it easier with javascript?

[redarrow]

[code]

<?php

$db=mysql_connect('localhost' , 'xxxxxx' , 'xxxxxx' );
mysql_select_db('xxxxxx',$db);

$query="select from xxxxxx where xxxxx='xxxxx'";

$result=mysql_query($query);

echo"<select name='xxxxxx'>";

while($record=mysql_fetch_assoc($result)){

echo" <option value=' '".$record['xxxx']."'
'>'".$record['xxxxx']."'</option>";
}

echo"</select>";

?>[/code]



array way ok.

[code]

<?php

$x=array('php','asp','javascript');

echo"<select name='x'>";

foreach($x as $d){

echo"<option value='$d'>$d</option>";
}
echo"</select>";
?>
[/code]