PHP Forum

**Hawkallica** · 03-25-2005, 01:34 PM

I am new to php, and I'm trying to make a text based game, but for some reason I have some problems with my calculation on my buildings page. It doesn't give me the right ammount of free land and mountain I can build on. Here is a part of my code.

PHP Code:


			
$query = "SELECT * FROM building WHERE empname='$empname'";

$result = mysql_db_query($dbname, $query, $db);

$myrow = mysql_fetch_array($result);



//GET AMMOUNT OF LAND AND MOUNTAIN

$land = $myrow["land"];

$mountain = $myrow["mountain"];



//LAND

$home = $myrow["home"];

$farm = $myrow["farm"];

$barracks = $myrow["barracks"];

$gtower = $myrow["gtower"];



//MOUNTAIN

$goldmine = $myrow["gold"];

$ironmine = $myrow["iron"];

$lumber = $myrow["wood"];

$stonemine = $myrow["stone"];



//Find out how much free land

$builtland = ($home + $farm + $barracks + $gtower);

$freeland = ($land - $builtland); // = Free land



//Find out how much free mountain

$builtmountain = ($goldmine + $ironmine + $lumber + $stonemine);

$freemountain = ($mountain - $builtmountain); // = Free mountain

I think there is something on these lines
$freeland = ($land - $builtland); // = Free land
AND
$freemountain = ($mountain - $builtmountain); // = Free mountain

cause $mountain and $land is right, and $builtmountain and $builtland is right aswell.

sign up if you want to, I have just 3 pages complete, http://www.HAVOKband.com/GAME/

**Rufo** · 03-25-2005, 02:50 PM

I can't see anything wrong with those two lines, unless they are strings (though typecasting should have taken care of this).

My only suggestion is that the values are not being selected from the database properly. Try var_dump($myrow); to check what's going on.

Rufo.