[SOLVED] mysql_fetch_array() error

[chris_rulez001]

hi, can someone help me with this please?

 

code:

 

<?php
$host="localhost"; // Host name
$username="########"; // Mysql username
$password="#########"; // Mysql password
$db_name="#######"; // Database name
$tbl_name1="users"; // Table name
$username2 = $_SESSION['username'];

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

$sql1="SELECT * FROM $tbl_name1 WHERE username='$username2'";
// OREDER BY id DESC is order result by descending
$result1=mysql_query($sql1);

$rows1=mysql_fetch_array($result1);
?>

<table cellpadding="4" cellspacing="1" border="0" width="100%">

<tr>

<td style='background-color: #FFFFFF'>

<?php
$username1 = $_SESSION['username'];
$userlevel = $rows1['usertype'];

$page = $_REQUEST['action'];

if (!isset($_SESSION['username']) == true)
{
echo "<strong>Error:</strong> <br/> You are not allowed to access the administration panel.";
}
else
{
if (!strpos($username1, $userlevel) == true)
{
echo "<strong>Error:</strong> <br/> You are not allowed to access the administration panel.";
}
else
{
echo "<a href='?action=create_board'>Create Board</a>"; // admin panel not finished
}
}
?>

</td>

</tr>

</table>

[kirk112]

What error are you getting?

 

if there is an error in the sql try changing

 

$result1=mysql_query($sql1);

to

$result1=mysql_query($sql1) or die(mysql_error());

 

This will give you any error in the sql.

 

 

[chris_rulez001]

What error are you getting?

 

if there is an error in the sql try changing

 

$result1=mysql_query($sql1);

to

$result1=mysql_query($sql1) or die(mysql_error());

 

This will give you any error in the sql.

 

 

 

yes i did give me a error, i was querying a table that didnt exist.

 

thanks for your help