<?php
$name = $_GET["name"]
$details = array();
$query = mysql_query("SELECT * FROM users WHERE username='".$_GET["name"]."'");
$query2 = mysql_query("SELECT * FROM users");
$rowshow = mysql_fetch_array($query);
$rowshow2 = mysql_fetch_array($query2);
if($_GET["name"]):
if($_GET["name"] == $rowshow2["name"]):
$details["name"] = $rowshow["username"];
$details["age"] = $rowshow["age"];
# You can add more details.
echo "This person is named ".$details["name"];
echo "This person is ".$details["age"]." years old.";
# You can add more echos !
else:
echo "Name doesn't exist!";
endif;
else:
echo <<< END
<form method='get'>
Please select one person's name !
<select name='name'>
<option>{$rowshow2["name"]}</option>
</select>
</form>
END;
endif;
?>