<?php
// Otherwise we connect to our Database
//include('db_login.php');
$connection = mysql_connect("localhost", "alarm", "") or die (mysql_error());
mysql_select_db (alarm_codes);
$find = $_POST['alarm'];
echo $_POST['searching'];
//This is only displayed if they have submitted the form
if ($_POST['searching']=="")
//If they did not enter an alarm we give them an error
if ($find == ""){
echo "

You forgot to enter an alarm code

” ;
exit;
}
// We preform a bit of filtering
$find = strtoupper($find);
$find = strip_tags($find);
$find = trim ($find);
//Now we search for our search term, in the field the user specified
$sql = “select * from codes where codes like ‘%” . $find . “%’ “;
$data = mysql_query($sql);
echo (“Searched For:
” .$find . “\n” );
//And we display the results
while($result = mysql_fetch_array( $data)) {
echo ‘

Result:

‘.$result;
echo $result['codes'] . “

” . $result['description'] .”

” ;
}
//This counts the number or results – and if there wasnt any it gives them a little message explaining that
$anymatches=mysql_num_rows($data);
if ($anymatches==0)
echo “Sorry, but we can not find an entry to match your query. Please add this alarm

\n”;
//And we remind them what they searched for
“mysql_free_result”;
(“mysql_close”);
?>

i need the add button to add alarm codes to the database and modify button to modify alarm codes already in the database