[Resolved] Query Question

[whitebread]

Well I give up! I have done my best but I can not figure out why this query does not work.

I am trying to have a query check (after a user logs into the system) for the user's secuirty level. The way i would like it to work is if the cookie is set check the database for the security level of the username defined in the cookie.

Here's the code that does not work.

<?php
ob_start();
if (!isset($_COOKIE['login'])){
		header('location: login.php');
		} 

include('mysql_connect_login.php');

$sql = "select level from users where username = '" . $_COOKIE['login'] . "'";
if ($sql['level'] >= "2") {
header('location: ../tech_supp.php');
      } else {
       print "<script>alert('You do not have enough access');</script>";

mysql_close();
}
?>

What is happening is well, nothing either the query does not return what i need or it seems to ignore my if statement.

[whitebread]

It's OK, I found my problem.

Here's the code that works,

<?php
ob_start();
if (!isset($_COOKIE['login'])){
		header('location: login.php');
		} 

include('mysql_connect_login.php');

$sql = "select level from users where username = '" . $_COOKIE['login'] . "'";

$query_run = mysql_query($sql);
$query_res= mysql_fetch_array($query_run);

if ($query_res['level'] >= "4") {
header('location: ../test.php');
} else {
print "<script>alert('You do not have enough access');</script>";


mysql_close();
}
?>

I was missing these 2 lines,

$query_run = mysql_query($sql);
$query_res= mysql_fetch_array($query_run);