<?php
$dbhost = '10.176.235.54';
$dbuser = 'user';
$dbpass = 'pass';
$dbname = 'db';

$c = mysql_connect($dbhost, $dbuser, $dbpass) or die('Error connecting to mysql');

mysql_select_db($dbname);


if(isset($_POST['name'])) {

$name=mysql_real_escape_string($_POST['name']);
$q=mysql_query("SELECT * FROM will WHERE tNAME='{$name}'",$c) or die(mysql_error());

if(mysql_num_rows($q) == 0) { echo "No match :["; }
else {
$r=mysql_fetch_array($q);
echo "Name: {$r['tNAME']} Value: {$r['tVALUE']}<br>";
}


} //end of isset
else { //its not set
echo "
<form action=william.php method=post>
Name: <input type=text name=name>
<br><input type=submit value=Search>";
}
?>