displaying data from a database

[oldspicelong]

ok i know how to display data for a user who is logged in but how want to make it so other people can view another person info. I want to display all the user names from the database using php and then when a user clicks on the users name it displays that users information

[oldspicelong]

iv worked on the script myself this is all i have done of it so far

 

<?php
session_start();

if(!isset($_GET['user']))
{
echo "You have not selected a user to fight!<br><br>";
$NPCS = mysql_query("SELECT * FROM `users` ");
while($Show = mysql_fetch_array($NPCS))
  {
  echo "<a href=\"profileviewer.php? Action=view&user=" . $Show['username'] . "\">" . $Show['username'] . "</a><br>";
  }
exit();
}

$NPC = mysql_escape_string($_GET['user']);
$username = $_COOKIE['ID_my_site'];
if($_GET[Action] = view)
{
if($username == $NPC){echo "You cannot fight yourself! <br><br>"; exit();}
$UserS = mysql_query("SELECT * FROM `users` WHERE username='$username'");
$UserS = mysql_fetch_array($UserS);
$UserH = $UserS['health'];
echo "Name:".$UserS['username']."<br/>";

?>