mysql database fields into html list/menu

mysql database "myshop" table "einheit"
"id" field int(255) auto_increment
"name" field varchar(255)

===============
= id = name =
===============
= 1 = Stück =
= 2 = Packung=
= 3 = kg =
= 4 = Box =
===============


I would like to insert these fields into PHP side list/menu , I
already some tried however did not create

my php code

<?
$dbhost = "localhost";
$dbname = "myshop";
$dbuser = "franky";
$dbpass = "pass";

mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db($dbname);

$sql="select * from einheit";
$result=mysql_query($sql);
$zeile = mysql_fetch_array($result);
echo "$zeile[id] , $zeile[name]";

?>
<select name="select">
<option value="$zeile[id]" selected>$zeile[name]</option>
</select>




ask for assistance Thanks!

re: mysql database fields into html list/menu

franz@fuka.at (Franz Josef Fuka) wrote:
[color=blue]
> I would like to insert these fields into PHP side list/menu , I
> already some tried however did not create
>
> <?
> $dbhost = "localhost";
> $dbname = "myshop";
> $dbuser = "franky";
> $dbpass = "pass";
>
> mysql_connect($dbhost,$dbuser,$dbpass);
> mysql_select_db($dbname);
>[/color]

You'd have to loop through the result set:

$sql="select * from einheit";
$result=mysql_query($sql);
echo "<select name=\"select\">\n";
while($zeile = mysql_fetch_array($result)){
?>
<option value="<?php echo $zeile['id']; ?>"><?php echo $zeile['name'];
?></option>
<?php
}
?>
</select>

HTH;
JOn