[SOLVED] My rank system won't work

[marklarah]

You're probably all bored by now of all my problems, but anyway, for the rank system on my site, on my include file, i have this:

 

    $userlevel = $_SESSION['lvl'];

$qry = mysql_query("SELECT * FROM `ranks` WHERE `number` = '$userlevel'");
  $rowq = mysql_fetch_array($qry);

$userrank = $rowq['title'];

 

which should work.

 

I have this on the page i want to display it:

 

<table width="98%" align="center" border="1">
<?
  while ($tnum = mysql_fetch_assoc($tarticles)){



$userp = $tnum['username'];
$message = $tnum['message'];
echo '<tr><td width="22%" align="center">'; 


echo $userp;


echo '</td><td width="78%" align="left">';
echo "Stuff";
echo '</td></tr>';


echo '<tr><td width="22%" height="'.$height.'" valign="top" align="center">';
// $userp = $rowl['username'];
// $message = $rowl['message'];



echo '<b>'.$userrank.'</b>';
echo 'Level: '.$userlevel;
echo '</td><td wdth="78%" height="'.$height.'" valign="top" align="left">';

echo $message;
echo '</td></tr>';
}



?>
</table>

 

It only displays the level, not the rank title, also i get this from the include file:

 

Warning: mysql_query() [function.mysql-query]: Access denied for user 'tlscom'@'localhost' (using password: NO) in /home2/tlscom/public_html/bar.php on line 138

 

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home2/tlscom/public_html/bar.php on line 138

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home2/tlscom/public_html/bar.php on line 139

 

And yes, I can connect to my database fine.

 

 

 

 

 

[marklarah]

*slaps head* I didn't have the database include file.

 

 

delete this topic mods please.