Jump to content


Photo

grabbing info from database problem


  • Please log in to reply
1 reply to this topic

#1 fix3r

fix3r
  • Members
  • PipPip
  • Member
  • 22 posts

Posted 22 October 2006 - 08:27 PM

I didn't know where to put this, so I put it in both places. If this isn't aloud please delete the place where it is innapropriate to put it in.

http://www.phpfreaks.com/forums/index.php/topic,112357.0.html

On the top of my page it shows the stats of players if they are logged in..for example, money used..attacks..unread messages..ect. Or if they aren't logged in, it telle them that they need to log in.

When someone logs in, it redirects them to the menu page where it also gives them a little info about the person.

Now here is where the problem is, when they log in and it redirects you to the page, neither top where it shwos the player's stats or the menu tells them how much of "whatever" they have. It says they have 0. But once you refersh it tells them an exact ammount of what they have.

I'm going to show you some of my code but if anyone needs anymore to figure out what the problem would be please tell me.

Config:
$result = mysql_query("SELECT * FROM users WHERE username='" . decrypt($_SESSION['login']) . "'");
$rs = mysql_fetch_array($result);

Part of index where info is displayed:
echo'<td width="15%">Money:&nbsp;<b>$' . number_format($rs['moneyout']) . '</b></td>';
echo'<td width="15%">Power:&nbsp;<b>' . number_format($rs['power']) . '</b></td>';
echo'<td width="15%">Attacks:&nbsp;<b>' . number_format($rs['attacks']) . '</b></td>';

I apprecate your help, thank you.

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 22 October 2006 - 08:53 PM

Sounds like it might be cached version of the page, you're pulling an old session somehow.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users