Showing different links for logged in users with special ranks?

SeanKann

What i'm tryin' to do is the following

I have my website up and running working great.. I did a redesign of it and I have now set up logging in and out of the website.

I have sessions working great with no probs that I have seen

What I want to do is when the user loggs into the page it will show them different links that say a guest that hasn't logged in yet. I've tried teh following

mysql_connect($DBhost,$DBuser,$DBpass);
@mysql_select_db($DBName) or die( "Unable to select database");

$query="SELECT * FROM $table";
$result=mysql_query($query);

if($user_level == 1);
echo "$post";
$post = "my links here.html";
mysql_close();
?><br>

I want so people that are user_level 1 to have certain links.. user_level 1 is coming from the database.. Example like being able to post to the main page. I have setup a different page that they can goto to post info. Which works with the sessions.

But once they login on the main page they can't see the link.

Any ideas would be great. or if there is a better way of doing this please let me know

Thanks in advance,

Davy

Firstly this code is wrong is many ways. This (untested) code should work better.

mysql_connect($DBhost,$DBuser,$DBpass);
@mysql_select_db($DBName) or die( "Unable to select database");

$query="SELECT * FROM $table";
$result=mysql_query($query);

if($result['user_level'] == 1);
{
$post = "my_links_here.html"; // highly recommended that webpages not be saved with spaces btw
}
echo "<a href='".$post."'>This</a> is for user level 1.";
mysql_close();
?><br>

But me personally I would do this whole db query thing every time. I'd set up that query when the user logs in, the user's session has thier details saved to it so then instead of comparing mySql result variable $result['user_level'], you would only need to compare it to $_SESSION['user_level'] which is quicker and easier.