Something very basic

[moboter]

Is it possible to use the other field later on the same page?
if so how do I get the vlaues?

<?php
    $link = mysql_connect("localhost", "user", "pw")
        or die("Konnte die Verbindung nicht herstellen: " . mysql_error());
    print ("Verbindung erfolgreich");
    mysql_selectdb("db_name");
    $sql1 = mysql_query("select * from arzt order by nachname");
    echo"<select name='name'>";
    echo "<option value>Bitte ausw&auml;hlen</option>";
    while($show = mysql_fetch_array($sql1))
        {


        echo "<option value=\"" . $show[3] . "\" ";
    if( !empty($_POST['name']) && ($show[3] == $_POST['name']) ) echo "SELECTED";
    echo ">" . $show[3] . "</OPTION>\n";

    }
echo "</select>";


mysql_close($link);
?>

[Installer]

You could store the values into an array:

    while($show = mysql_fetch_array($sql1)) 
        { 
        $storage_array[] = $show[2];

        echo "<option value=\"" . $show[3] . "\" "; 
    if( !empty($_POST['name']) && ($show[3] == $_POST['name']) ) echo "SELECTED"; 
    echo ">" . $show[3] . "</OPTION>\n"; 

    }

// Then, for example:
foreach ($storage_array as $value) {
    echo $value;
}

If that's what you mean.