Untitled

<?php
$db_hostname = 'localhost';
$db_username = 'root';
$db_password = '';
$db_database = 'limiti';

// Database Connection String
$con = mysql_connect($db_hostname,$db_username,$db_password);
if (!$con)
  {
  die('Fel: ' . mysql_error());
  }

mysql_select_db($db_database, $con);
?>


    <head>
        <meta charset="utf-8" />
        <title></title>
    </head>
    <body>
<form action="" method="post">
Sök: <input type="text" name="term" /><br />
<input type="submit" value="Submit" />
</form>


<?php
if (!empty($_REQUEST['term'])) {

$term = mysql_real_escape_string($_REQUEST['term']);

$sql = "SELECT * FROM limited WHERE serie_nr LIKE '%".$term."%'";
$r_query = mysql_query($sql);
while ($row = mysql_fetch_array($r_query)){
echo '<br /> Namn: ' .$row['namn'];
echo '<br /> SerieNummer: '.$row['serie_nr'];
echo '<br /> Nummer: '.$row['nummer'];
}

}
?>