I have this code:
<html>
<head>
<title>Klant informatie systeem</title>
<link href="css/style.css" rel="stylesheet" type="text/css">
</head>
<body bgcolor="#0099FF">
<?php
//dbase connection
$Host = "localhost";
$Gebruiker = "";
$Wachtwoord = "";
$DBNaam = "***";
$Verbinding = mysql_connect($Host, $Gebruiker, $Wachtwoord);
$KlantenTabel ="Klanten";
// SQL statement
$Opdracht = "SELECT klantnr, naam, voorletters FROM $KlantenTabel";
$Opdracht2 = "SELECT klantnr, naam, voorletters, adres, huisnummer, postcode, plaats, telefoon, email FROM $KlantenTabel WHERE klantnr = ";
$tekst = mysql_db_query($DBNaam, $Opdracht, $Verbinding);
?>
<form method=post>
<table width="420" border="1">
<tr>
<td colspan="2" class="kop1">Bijwerken klantprofiel</td>
</tr>
<tr valign="baseline">
<td width="91" class="tekst1">Kies een klant</td>
<td width="329" class="tekst1">
<select name="klantnummer">
<?php
while ($post = mysql_fetch_array($tekst)){
print"<option> $post[klantnr]-$post[naam]--$post[voorletters] </option> <br>";
}
?>
</select> </td>
</tr>
</table>
</form>
<form action="test" method=post>
<table width="420" border="1">
<tr valign="baseline">
<td width="92" class="tekst1">Naam</td>
<td width="312">
<input type="text" name="naam">
</td>
</tr>
<tr valign="baseline">
<td width="92" class="tekst1">Voorletters</td>
<td width="312">
<input type="text" name="voorletters">
<span class="tekstwazig">(E.M.)</span></td>
</tr>
<tr valign="baseline">
<td class="tekst1">Adres</td>
<td>
<input type="text" name="adres">
</td>
</tr>
<tr valign="baseline">
<td class="tekst1">Huisnummer</td>
<td>
<input type="text" name="huisnummer">
</td>
</tr>
<tr valign="baseline">
<td height="27" class="tekst1">Postcode</td>
<td>
<input name="postcode" type="text" size="6" maxlength="6">
<span class="tekstwazig">(9742LA)</span> </td>
</tr>
<tr valign="baseline">
<td class="tekst1">Plaats</td>
<td>
<input type="text" name="plaats">
</td>
</tr>
<tr valign="baseline">
<td class="tekst1">Telefoon</td>
<td>
<input name="telefoon" type="text" size="10" maxlength="11">
<span class="tekstwazig">(050-6732726)</span></td>
</tr>
<tr valign="baseline">
<td class="tekst1">email</td>
<td>
<input name="email" type="text" size="50">
</td>
</tr>
<tr valign="bottom">
<td colspan="2" class="red"><div align="right"><br>
<input name="update_klant" type="submit" value="Update klantgevens">
<input name="verwijder_klant" type="submit" value="Verwijder klant">
</font> </div></td>
</tr>
</table>
</form>
<?php
mysql_close ($Verbinding);
?>
</body>
</html>
There is a dropdown box on the top of this screen. If select one of the options in this dropdown box there should be filled in all the information in the other form correpondending with the one I selected. Difficult story but can anyone help me!
Thank you.
