This is the code for the select statement
echo "<tr><td>Arzt</td><td>";
$sql1 = mysql_query("select * from arzt order by nachname");
echo"<select name=\"name\">";
while($show = mysql_fetch_array($sql1))
{
echo "<option>$show[3]</option>";
}
echo "</select></td>";
{
echo "<option value=\"".$show."\" ";
if ( !empty($_POST['name']) && ($show == $_POST['name']) ) echo "selected";
echo"\"".$show."</option>\n";
}
echo "</select></td></tr>\n";
if ( !empty($_POST['name']) ) echo "value=\"".$_POST['name']."\"";
echo "</td></tr>\n";
Here comes the code where I want to make the changes
echo "<tr><td>Beschreibung</td><td>\n";
echo "<textarea name=\"description\" rows=\"5\" cols=\"30\">";
$sql1 = mysql_query("select * from arzt where 'nachname' like '$show'");
$show = mysql_fetch_array($sql1);
echo "<h2>$show[1] $show[2] $show[3]</h2><br>
$show[4] $show[5]<br>
$show[6] $show[7]<br>
Telefon: $show[8]
Fax: $show[9]";
if ( !empty($POST['description']) ) echo stripslashes($POST['description']);
echo "</textarea></td></tr>\n";