Jump to content

Archived

This topic is now archived and is closed to further replies.

fix3r

PHP grabbing info from database problem

Recommended Posts

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.

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

[b]Part of index where info is displayed:[/b]
[code]
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>';
[/code]

I apprecate your help, thank you.

Share this post


Link to post
Share on other sites
Sounds like the session isn't set on the first pageview (is accessible as $_SESSION)

Share this post


Link to post
Share on other sites
[quote author=alpine link=topic=112357.msg455917#msg455917 date=1161547057]
Sounds like the session isn't set on the first pageview (is accessible as $_SESSION)
[/quote]

How do I make the session set on the first page view. In the index page I have started the session but I haven't started the session on the menu page because the menu page is included in the index.

[code]
<?php
session_start();
include "config.php";
ob_start();
login_check();
?>
[/code]

Thanks for your help.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.