Help Me With My Problem [Solved]

[amir]

Hello , I'm New On Forum
I have Problem With Battle.php:
When I test it i see this page ( I don't see player info )




This is My battle.php Code

Code: Select all

<?php
include 'connect.php';




$playerinfo="SELECT * from players where name='player1'";
$playerinfo2=mysql_query($playerinfo) or die("could not get player stats!");
$playerinfo3=mysql_fetch_array($playerinfo2);

$playerhp = $playerinfo3['hpoints'];
$playerattack = $playerinfo3['attack'];
$playerdefense = $playerinfo3['defense'];

if (isset($_GET['creature']))
{
   $creature=$_GET['creature'];
   $creatureinfo="SELECT * from creatures where name = '$creature'";
$creatureinfo2=mysql_query($creatureinfo) or die("could not get the creature you were fighting!");
$creatureinfo3=mysql_fetch_array($creatureinfo2);

}
else
{
  $creatureinfo="SELECT * from creatures order by rand() limit 1";
$creatureinfo2=mysql_query($creatureinfo) or die("could get a creature!");
$creatureinfo3=mysql_fetch_array($creatureinfo2);
}

$creature = $creatureinfo3['name'];
$creaturehp = $creatureinfo3['hpoints'];
$creatureattack = $creatureinfo3['attack'];
$creaturedefense = $creatureinfo3['defense'];

/////player info
echo "<u> " . $playerinfo3['name'] . "</u><br>";
echo "Hit points = " . $playerhp . "<br>";
echo "Attack = " . $playerattack . "<br>";
echo "Defense = " . $playerdefense . "<br><br><br>";

///////creature info
echo "<u> " . $creatureinfo3['name'] . "</u><br>";
echo "Hit points = " . $creaturehp . "<br>";
echo "Attack = " . $creatureattack . "<br>";
echo "Defense = " . $creaturedefense . "<br><br><br>";

echo "<a href='attack.php?creature=$creature'>Attack!";

?>

Thank You

[Chris]

Does player1 exist?

After line 9:

Code: Select all

$playerinfo3=mysql_fetch_array($playerinfo2); 

place this (line 10)

Code: Select all

echo "player1 exists: " . mysql_num_rows($playerinfo3); 

if it says "player1 exists: 0", that's your problem.

[amir]

solved .Thank you so much
When You said That Does player1 exist , i checked again and i had spelling mistake (palyer1) then i change it to player1
Thanks

[amir]

Does player1 exist?

After line 9:

Code: Select all

$playerinfo3=mysql_fetch_array($playerinfo2); 

place this (line 10)

Code: Select all

echo "player1 exists: " . mysql_num_rows($playerinfo3); 

if it says "player1 exists: 0", that's your problem.

solved .Thank you so much
When You said That Does player1 exist , i checked again and i had spelling mistake (palyer1) then i change it to player1
Thanks

[SpiritWebb]

If this is solved, please edit your first post and place [solved] in the subject. Thanks!