<html-code-design>

<?
// Connect to the database
mysql_connect('server', 'username', 'password');
mysql_select_db('database');

// Only when the form is submitted and id is number only
if ($_SERVER['REQUEST_METHOD'] == 'POST' && preg_match('^[0-9]+$', $_POST['infoID'])
{   $result = mysql_query('SELECT infoTitle, infoText FROM infos WHERE infoID=$_POST['infoID'] LIMIT 1');
    if (mysql_num_rows($result) > 0)
    {   $row = mysql_fetch_assoc($result);
         echo '<b>'.$row['infoTitle'].'</b><br />';
         echo $row['infoText'];
     }
     else
     {    echo 'Unknown ID';
     }
}
?>
<form name="infoForm" action="" method="post">
<select name="infoID" size="1">
  <?
  $result = mysql_query('SELECT infoID, infoTitle FROM infos ORDER BY infoTitle');
  while ($row = mysql_fetch_assoc($result))
  {   echo '<option value="'.$row['infoID'].'">'.$row['infoTitle'].'</option>';
  }
  ?>
</select>
</form>

<?
// Closes the database
mysql_close();
?>