When I press the search button I get a blank screen. Can anybody tell me why?
search.php
<html>
<head>
<title>Search</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
</head>
<body>
<form name="refsearch" method="post" action="searchresults.php">
<input name="search" type="text" size="25" maxlenth="8" />
<input type="submit" name="submit" value="search" />
</form>
</body>
</html>
searchresults.php
<?php
$db = mysql_connect("xxxxxx","xxxx","xxxxxx") or die("Cannot connect to server");
mysql_select_db("xxxxx",$db) or die("Cannot connect to the database");
if (!isset($_POST['search'])) {
}
$search_sql = "SELECT * FROM admin WHERE Ref Like '%".$_POST['search']."%'";
$search_query = mysql_query($search_sql);
if (mysql_num_rows($search_query) != 0) {
$search_rs = mysql_fetch_assoc($search_query);
?>
<?php
if (mysql_num_rows($search_query) != 0) {
do {
?>
<p><?php echo $search_rs['firstname']; ?></p>
<?php
} while ($search_rs = mysql_fetch_assoc($search_query));
} else {
echo "Card Number Not on Database" ;
}
}
?>
<?php
error_reporting(E_ALL);
?>