<?php echo '<?xml version="1.0" encoding="iso-8859-1"?>';?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<head>
  <title>exempel2</title>
  <meta name="GENERATOR" content="Quanta Plus" />
  <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
  <link rel="stylesheet" type="text/css" href="../css/mall.css" />
</head>
<body>
<form method="post" action="adresser4.php">Adressbok, skriv in Efternamn.<br /><br />
Efternamn:&nbsp;<input type="text" size="25" name="sql" /><br /><br />
<input type="submit" name="adress" value="Adress" />
</form>
<?php
if(isset($_POST['sql'])) 
 {
  $länk=mysql_connect("localhost","hakan","hakan");
  $query='SELECT * FROM ADRESSER4 WHERE EFTERNAMN="'.$_POST['sql'].'"';
  $result=mysql_db_query("MIN_DATA","$query");
?>
<table border="1" cellpadding="5">
<tr>
<?php
for($i=0;$i<=(mysql_num_fields($result))-1;$i++)
 {
  echo"<th>".mysql_field_name($result,$i)."</th>";
 }
?>
</tr>
<?php 
while($rad=mysql_fetch_row($result))
 {
  echo"<tr>";
   for($i=0;$i<=(mysql_num_fields($result))-1;$i++)
    {
      echo"<td>".$rad[$i]."</td>";
    }
  echo"</tr>";
 } 
mysql_close($länk);
}
?>
</table>
<hr />
<form method="post" action="adresser4.php">Telefonbok, skriv in ID-nummer.<br /><br />
ID-nummer:&nbsp;<input type="text" size="5" name="sql2" /><br /><br />
<input type="submit" name="telefon" value="Telefon" />
</form>
<?php
if(isset($_POST['sql2'])) 
 {
  $länk=mysql_connect("localhost","hakan","hakan");
  $query='SELECT * FROM TELEFON1 WHERE ID="'.$_POST['sql2'].'"';
  $result=mysql_db_query("MIN_DATA","$query");
?>
<table border="1" cellpadding="5">
<tr>
<?php
for($i=0;$i<=(mysql_num_fields($result))-1;$i++)
 {
  echo"<th>".mysql_field_name($result,$i)."</th>";
 }
?>
</tr>
<?php 
while($rad=mysql_fetch_row($result))
 {
  echo"<tr>";
   for($i=0;$i<=(mysql_num_fields($result))-1;$i++)
    {
      echo"<td>".$rad[$i]."</td>";
    }
  echo"</tr>";
 } 
mysql_close($länk);
}
?>
</table>
</body>
</html>
