Untitled

<?
session_start();
if(!session_is_registered(myusername)){
header("location:index.php");
}
?>
<html>
<head>
<link rel="stylesheet" type="text/css" href="style.css" />
<title>
[R.I.P] - Astro/Player Database - Database
</title>

<div id="banner">
<img src="graphics/banner.jpeg" alt="banner"/>
</div>
<script language="javascript">
var state = 'hidden';

function showhide(layer_ref) {

if (state == 'visible') {
state = 'hidden';
}
else {
state = 'visible';
}
if (document.all) { //IS IE 4 or 5 (or 6 beta)
eval( "document.all." + layer_ref + ".style.visibility = state");
}
if (document.layers) { //IS NETSCAPE 4 or below
document.layers[layer_ref].visibility = state;
}
if (document.getElementById && !document.all) {
maxwell_smart = document.getElementById(layer_ref);
maxwell_smart.style.visibility = state;
}
}
//-->
</script>
</head>
<body>
<br>
<br>
<br>
<div id="nav" align="left">
<ul>
    <li><a href="/AE/Home.php">Home</a></li>
    <br>
    <li><a href="/AE/Members.php">Members</a></li>
    <br>
    <li><a href="/AE/Profile.php">Profile</a></li>
    <br>
    <li><a href="/AE/Contact.php">Contact</a></li>
</ul>
</div>
<div id="click" align="right">
<a href="javascript://" onclick="showhide('insert')">Click</a> To Add Member! </div>
<div id="insert" align="right" style="visibility:hidden;">
<b>Insert Player Here!</b>
<form action="insert.php" method="post">
ID <input type="text" name="ID" />
<br>
Name <input type="text" name="Name" />
<br>
Guild <input type="text" name="Guild" />
<br>
Location <input type="text" name="Location" />
<br>
<input type="submit" value="Add to Database" />
</form>
</div>
<div id="Search" div style="position: absolute; top: 350px; right: 530px;">
&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp<b>Input Guild/ID or Player Name.</b>
<form name="search" method="post" action="<?php $_SERVER[PHP_SELF]?>">
 Seach for: <input type="text" name="find" /> in
 <Select NAME="field">
 <Option VALUE="Name">Name</option>
 <Option VALUE="Guild">Guild</option>
 <Option VALUE="ID">ID</option>
 </Select>
 <input type="hidden" name="searching" value="yes" />
 <input type="submit" name="search" value="Search" />
 </form>

<?php
  if ($searching =="yes"){
    echo "<h3>Search Results</h3><p>";
    if ($find == ""){
      echo "<p>Please Enter a search term";
      exit;
    }

    mysql_connect("localhost", "AE", "") or die(mysql_error());
    mysql_select_db("ae") or die(mysql_error());
    $find = strtoupper($find);
    $find = strip_tags($find);
    $find = trim ($find);

    $query = mysql_query("SELECT * FROM astros WHERE upper($find) LIKE'%$find%'");
    while($result = mysql_fetch_array($query)){
      echo $result['ID'];
      echo " ";
      echo $result['Guild'];
      echo "<br>";
      echo $result['Name'];
      echo "<br>";
      echo "<br>";
    }

    $matches=mysql_num_rows($query);
    if ($matches == 0){
      echo "Sorry, we can not find an entry to match your query<br><br>";
    }

    echo "<b>Searched For:</b> " .$find;
  }
?>
</form>
</div>
</body>
</html>