ok, hvor helle skal jeg placere disse tables og textboxe ? nede i selve sql scriptet eller oppe i form scriptet ?
siden ser sådan ud, hvor skal jeg så placere det for at det kommer til at virke ?
<form method='post' action='<?=$PHP_SELF?>'>
<table border="0" cellspacing="0" width="226" height="137">
<tr>
<td width="224" height="135"><font face="Arial">Indtast Telefon Nr. </font><table
border="0" cellspacing="0" width="205">
<tr>
<td width="58"><input type="text" name="Tlf" value=""
onfocus="if(this.value=='E-mail')this.value='';"
onblur="if(this.value=='')this.value='E-mail';" size="22"></td>
<td width="57"><input type="submit" name="send" value="Søg"></td>
</tr>
</table>
</td>
</tr>
</table>
</form>
//Hvor skal jeg placere det her ?
<form method='get' action='<?=$PHP_SELF?>'>
<table border="0" cellspacing="0" width="289">
<tr>
<td width="287">Navn:<input type="text" name="Navn" size="20"></td>
</tr>
<tr>
<td width="287">Kunde Nr.: <input type="text" name="Kundenr" size="20"></td>
</tr>
<tr>
<td width="287">Udlejnings Nr.: <input type="text" name="Udlejningskode" size="20"></td>
</tr>
<tr>
<td width="287">Telefon Nr.: <input type="text" name="Tlf" size="20" values="<?php echo $row['Tlf']; ?>"></td>
</tr>
</table>
</form>
//hertil
<?php
//MySQL configuration start
$host = "localhost"; //Enter the address to your MySQL server here
$user = "video"; //Enter the username to your MySQL server here
$pass = "video"; //Enter the password to your MySQL server here
$db = "videobutik"; //Enter the database on your MySQL server here
//MySQL configuration end
$Kundenr = $_POST['Kundenr'];
$Navn = $_GET['Navn'];
$Tlf = $_POST[Tlf];
$Udlejningskode = $_POST[Udlejningskode];
mysql_connect("$host", "$user", "$pass");
mysql_select_db($db);
$result = mysql_query("select * from Kunde where Tlf='$Tlf'") or die(mysql_error());
$row = mysql_fetch_array($result);
echo "$row[Navn]<br>$row[Kundenr]</a><br> - $row[Udlejningskode]<br>$row[Tlf]<br><br>";
mysql_close();
?>
