Page 1 of 1

Promblem with Battle.php

Posted: Mon Jan 07, 2013 1:21 pm
by Syppii
I have these problems when I run these codes:
( ! ) Notice: Undefined index: denfense in C:\wamp\www\tutorial\battle.php on line 13
Call Stack
# Time Memory Function Location
1 0.0017 376984 {main}( ) ..\battle.php:0

( ! ) Notice: Undefined variable: creatureinfo3 in C:\wamp\www\tutorial\battle.php on line 27
Call Stack
# Time Memory Function Location
1 0.0017 376984 {main}( ) ..\battle.php:0

( ! ) Warning: mysql_fetch_array() expects parameter 1 to be resource, null given in C:\wamp\www\tutorial\battle.php on line 27
Call Stack
# Time Memory Function Location
1 0.0017 376984 {main}( ) ..\battle.php:0
2 1.0607 390000 mysql_fetch_array ( ) ..\battle.php:27
player1

Code: Select all

<?php
include 'connect.php';




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

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

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

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

$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='battle.php?creature=$creature'>Attack!";

?>

Re: Promblem with Battle.php

Posted: Mon Jan 07, 2013 4:30 pm
by Mardonis
Did you mean to have defense instead of denfense on your first problem on line 13?

Re: Promblem with Battle.php

Posted: Tue Jan 08, 2013 6:51 am
by Winawer
You need to give $creatureinfo2 to mysql_fetch_array, not $creatureinfo3.