1 reply to this topic

[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..

[I360]

 <?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");
	
	}
	
?>

You had an erroneous semi colon at the end of the while clause.

Try that!