job[solved]

[pretender5552]

I set up a code so that when I clicked the link it would take me to a second page that would update my experience, energy and money but it isn't working, can someone tell me what i did wrong.

Code: Select all

<?php
include_once 'connect.php';

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

$jobsinfo="SELECT * from jobs where name='job1'";
$jobsinfo2=mysql_query($jobsinfo) or die("could no get player stats!");
$jobsinfo3=mysql_fetch_array($jobsinfo2);

$playerenergy = $playerinfo3['energy'];
$playerexperience = $playerinfo3['experience'];
$playercredit = $playerinfo3['credit'];
$jobsexperience = $jobsinfo3['experience'];
$jobsenergy = $jobsinfo3['energy'];
$rand1 = rand(308,375);



$newenergy = $playerenergy - $jobsenergy;
$updateexperience="update player set energy='$newenergy' where name='Bryan'";
  mysql_query($updateenergy) or die (mysql_error());

$newcredit = $playercredit + $rand1;
$updatecredit="update player set credit='$newcredit' where name='Bryan'";
  mysql_query($updatecredit) or die (mysql_error());

$newexperience = $playerexperience + $jobsexperience;
$updateexperience="update player set experience='$newexperience' where name='Bryan'";
  mysql_query($updateexperience) or die (mysql_error());

Echo "<a href='jobs.php'>Go Back</a>";

?>

[SpiritWebb]

I set up a code so that when I clicked the link it would take me to a second page that would update my experience, energy and money but it isn't working, can someone tell me what i did wrong.

Code: Select all

<?php
include_once 'connect.php';

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

$jobsinfo="SELECT * from jobs where name='job1'";
$jobsinfo2=mysql_query($jobsinfo) or die("could no get player stats!");
$jobsinfo3=mysql_fetch_array($jobsinfo2);

$playerenergy = $playerinfo3['energy'];
$playerexperience = $playerinfo3['energy'];
$playercredit = $playerinfo3['credit'];
$jobsexperience = $jobsinfo3['experience'];
$jobsenergy = $jobsinfo3['energy'];
$rand1 = rand(308,375);



$playerenergy - $jobsenergy;
$updateexperience="update player set experience='$playerenergy - $jobsenergy' where name='Bryan'";
  mysql_query($updateexperience) or die (mysql_error());

$playercredit + $rand1;
$updatecredit="update player set experience='$playercredit + $jobscredit' where name='Bryan'";
  mysql_query($updateexperience) or die (mysql_error());

$playerexperience + $jobsexperience;

$updateexperience="update player set experience='$playerexperience + $jobsexperience' where name='Bryan'";
  mysql_query($updateexperience) or die (mysql_error());

echo "<a href='jobs.php'>Go Back</a>";

?>]

You should have: (I think)

Code: Select all

where name='$Bryan'";

[pretender5552]

I have it set up so that there is only one player right now so I don't think I need to make it a variable I just have it this way so I can test it

[SpiritWebb]

What errors are you receiving? Need more info to try and help you...

[pretender5552]

Right now it is saying query empty so I can't even see if it is updating my stats

[pretender5552]

Ah got it had it $updateexperience when it needed to be $updateenergy I swear all this staring at code is giving me a headache.