[Jcbones]

What is the user ID, is it the auto increment column?

PHP Code:

<?php
session_start();
include_once("dbc.php");
   if(isset($_SESSION['userSession']) && !empty($_SESSION['userSession']))
 
        include_once("dbc.php");
$result = mysql_query("SELECT name FROM users WHERE username ='".$_SESSION['userId'] . "'"); 
$row = mysql_fetch_row($result);
$username = $row[0];
?>

Change the query (name) to reflect exactly what column your looking for. I'm assuming 'userid' is the integer of the row.

PS. you could always just save the username into a $_SESSION variable.