Indie-Resource.com

Code: Select all

$sql = "SELECT * FROM playermonster WHERE playerid = '$playerid'";
if ($result = mysql_query($sql)) {
     while ($row = mysql_fetch_row($result)) {
            $playerID = $row[0]; //stores the first field in a variable
            echo("Player ID: ".$playerID); //prints out the first field
            $playerName = $row[1]; //stores the second field in a variable
            echo("Player name: ".$playerName); //prints out the second row
            //..and so on, to print out or manipulate as many rows as you need. 
     } //end while
} else {
    echo("No results found.");
}

Code: Select all

$dogID = $row[0];    //Assuming the first column is the dog's unique ID
$dogName = $row[1];    //Assuming the second row is the dog's name
echo "<a href='dogselected.php?dogid=".$dogID."'>Select ".$dogName."</a><br />";

Code: Select all

//make short variables of the dog ID from the URL and player ID from the session variable
$dogSelected = $_GET['dogid'];
$playerID = $_SESSION['playerid'];

//query db to make sure player has not entered someone else's dog into the URL
$sql = "SELECT * FROM playerdogs WHERE playerid = '$playerID' AND dogid = '$dogSelected'";
$rec = mysql_query($sql);

if (!$rec) {
    echo "No dog found! Please try again!";
    exit();
}

//get dog info from results
$dogInfo = mysql_fetch_assoc($rec);

//grab any dog variables
$dogName = $dogInfo['name'];