whats wrong !!!

p0pb0b

This script worked before.. but I ran into some problems with DreamWeaver and I ended up (Control-Z) Undoing everything and it didnt work again
The script below is supposed to log someone in and give thme a message accoridng to thier level of useage and also assign Sessions but right now.. I have 5 users in db, and I tried ti login as a level 1 user which is admin and it gave me a pure blank page
then I tried level 2 and it gave me the login failure page.. theres no errors, just its not working right
Someone help please

<?php 
session_start(); 
header("Cache-control: private");

$db = mysql_connect(***********);
mysql_select_db("news",$db);

$name = addslashes($_POST['username']); 
$db_pass =  md5($_POST['password']); 
$sql = "SELECT ID FROM user WHERE Name= '$name' AND Password= '$db_pass' LIMIT 1"; 
	$result = mysql_query($sql);
$data_lev = mysql_fetch_array( $result );
if(mysql_num_rows($result) == 1)
{ 
	if($data_lev['level'] == 1)
   {
    $_SESSION['name'] = $name;
	$_SESSION['level'] = 1; 
	echo "Logged In, You will be redirected to Admin Page in 3 Seconds<br>";
	echo "<meta http-equiv=\"refresh\" content=\"3; url=./admin/\" />\n";
	}
	if($data_lev['level'] == 2)
		   {
    $_SESSION['name'] = $name;
	$_SESSION['level'] = 2; 
	echo "You have been logged in as a Regular User, You will be directed";
	echo "<meta http-equiv=\"refresh\" content=\"3; url=./index.php\" />\n";
	}
else { 
    echo "Login failure<br>";
	echo "<meta http-equiv=\"refresh\" content=\"3; url=login.html\" />\n";
	exit;
}	
 } 
?>

p0pb0b

comon someone must know 🙁

xnor82

i dont know the meta tag. so i did not use meta tag for redirect.

i use a javascript for redirection.

echo ("<html><body onload='goo(\"../Main_files/main.php\")'>");

it works...

p0pb0b

well the redirect worked before fine... but it didnt even echo out the words before the redirect and no errors either... any ideas?
wait did u mean the script worked fro u with those tags?

drag0n

use elseif() for the second if() the one for the level 1 user
It shouldnt be the proiblem but it "should" speed your script up.. I really dont see anything else... hes redirects are fine... I dont know whats wrong.... u say ur getting a blank page?

drag0n

p0pb0b

bump

jernhenrik

Seems to me that you only extract the ID from the query...which means you cant do:

if($data_lev['level'] == 1)

since level hasn't been extracted....try this instead:

$sql = "SELECT ID, level FROM user WHERE Name= '$name' AND Password= '$db_pass' LIMIT 1";

hth

p0pb0b

what is I do SELECT *
?

jernhenrik

Originally posted by p0pb0b
what is I do SELECT *
?

not sure what your are asking? but if you ask what
SELECT *
does...then it is: that all information in all rows that match your criteira is extracted.eg:

imagine your table has the following elements:
id, level, score, timeofplay etc.
then all information for any row that match your criteria is extracted...
http://www.mysql.com/doc/en/SELECT.html

p0pb0b

WHATS WRONG? IT DOESNT WORK!>!?!?!

coreyp_1

what changes have you made to your code since posting it here?

BTW, using switch instead of multiple if's would probably be both faster and easier to read.