Mysql query in a block

Nuke Cadet Joined: Sep 08, 2005 Posts: 3

I am developing a game intergrated into php-nuke and am having trouble with a block i am trying to get to work.

I want to display user specific information within a block.

I am using the following code but i know thw sql query will only check for the 1st row in the table.

-----------------------------------------------------------------------------------
if (eregi("block-Ruler.php", $_SERVER['PHP_SELF'])) {

Header("Location: index.php");

die();

}
global $db, $user, $cookie;
// query to get user info
$sql = "SELECT * FROM nuke_users";
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);

$content .= ""._BWEL." $row[username] \n";
$content .= "Level: $row[current_level] \n";
$content .= "EXP: $row[current_exp] \n";
$content .= "AS Modifier: $row[as_modifier] \n";
$content .= "DS Modifier: $row[ds_modifier] \n";
$content .= "SPD Modifier: $row[spd_modifier] \n";
$content .= "U-Credits: $row[uc] \n";
$content .= "Food: $row[food] \n";
$content .= "Energy: $row[energy] \n";
$content .= "Alliance: $row[alliance] \n";
$content .= "Ladder Points: \n";
$content .= " $row[ruler_ladderpoints] \n";
$content .= "Ladder Status: \n";
$content .= " $row[ruler_ladderstatus] \n";
$content .= "<a href=\"index.php\">Extended Stats</a> \n";

I need to access nformation of the user i who is logged into the site not the 1st row of the table. Who do i code the query?

Nuke Cadet Joined: Sep 08, 2005 Posts: 3

never mind i got it....