[SOLVED] admin panel

[dvayne]

<?php
session_start();
if($_SESSION['s_logged_n'] == 'true'){
include 'process.php';

$query = mysql_query("SELECT * FROM Users where position=admin") or die(mysql_error());
while($row = mysql_fetch_array($query));{

if(mysql_num_rows($query) > 0)
{   
if($row['Activated'] > 0){
	$_SESSION['adminl'] = 'true';
   		header("Location: adminpanel.php");
	}
	else{
	echo 'access denied';
	}
}	

}		



} else {

header("Location: login.php");
}
?>

 

please check my code

It displays access denied even if the position that is stored in database is admin..

any help would be appreciated..

[paul2463]

fora start off you can remove the semi colon from the "While($row" line it will stop it working

[Daniel0]

You also need to change the query to

SELECT * FROM Users where position='admin'

[dvayne]

thank you very much..