Here is what I have till now
Code: Select all
<center>
<form method= "POST" action = "search.php">
Search by username: <input type="text" name="sname" size="21"><br>
Search by nation name: <input type="text" name="nname" size = "21"><br>
<input type="submit" name="submit" value="submit">
</form>
</center>
<?php
if(isset($_POST["submit"]))
{
$oplayer = $_POST["sname"];
$nname = $_POST["nname"];
$oplayer = strip_tags($oplayer);
$nname = strip_tags($nname);
if($oplayer)
{
$query = "select name from players where name='$oplayer'";
$result = mysql_query($query) or die("Could not query table");
$result1 = mysql_fetch_array($result);
if($result1)
{
if(isset($_GET['nation']))
{$nation = $_GET['nation'];}
else{$nation = $oplayer;}
}
}
}
?>