How do you display users total records based on user level ?

Hi,



I have a login based on user level. Once user gets in depending on the user
level following is displayed. How do you lists total records belonging to
each user levels?

At the moment totals are same for both users which is wrong for level 1.
They both are sharing the same Mysql database. I need to enter some user
name variable some where and some how.



Any suggestions please?




if($_SESSION['user_level'] == 1){
echo "<font face=\"Arial\" size=\"2\"> Members Only -
($total_rsReport)Item Management<br>
<a href=mdbadd.php>Add more items</a><br />
<a href=report.php>Member Item Report / View / Update / Delet</a><br
/></font>";
}
if($_SESSION['user_level'] == 2){
echo "<font face=\"Arial\" size=\"2\"> Administration Purposes Only! -
($totalRows_rsReport) Item Management<br>
<a href=mdbadd.php>Add More Items</a><br/>
<a href=mdbGenreReport.php>Genre List</a><br/>
<a href=mdbTypeReport.php>Type List</a><br/>
<a href=mdbadminReport.php>Master Item Report / View / Update /
Delete</a><br />";
}
?>

Ok this is what I did and not deleting a record. All I am getting is a blank
screen after submitting and no records get deleted.
Where am I going wrong here ?

I've created a report.php page where check box and repeating region applied
to the whole row.And the whole row is within a form named delete Form which
starts like this (I've included session user as well)

<form action="mdbDeleteLogic.php?<?php echo $HTTP_SESSION_VARS['username'];
?>=<?php echo $row_rsReport['AlbumID']; ?>" method="post" name="deleteForm"
id="deleteForm">

Rows are displaying correctly as per user and their records.

Tuckbox has the record set binding code which is the AlbumID (numeric).
<?php echo $row_rsReport['AlbumID']; ?>

and the last form tag is <input type="submit" value="Delete Selected">

Now in my DeleteLogic.php page all I have starting with -
<?php require_once('../Connections/connMDB.php'); ?>
<?php
session_start();

?>
<?php ob_start(); ?>

then the Delete Record server behaviour which has the following parameters -
Primary Key Value
Conn
Table
Primary Key Column: AlbumID = Numeric checked
Primary Key value: URL Parameter = AlbumID
After Deleting Go to : report.php