hi, I am brand new on PHP MySql please I need your help, I make login page and it need to redirect if login member (member type in mysql data base) is admin to admin.php page or if login member is normal member it should redirect to member.php. here is code. <?php session_start(); //Database Information $dbhost = "localhost"; $dbname = "library"; $dbuser = "root"; $dbpass = ""; //Connect to database mysql_connect ( $dbhost, $dbuser, $dbpass)or die("Could not connect: ".mysql_error()); mysql_select_db($dbname) or die(mysql_error()); //Checks if there is a login cookie if(isset($_COOKIE['ID_my_site'])) //if there is, it logs you in and directes you to the members page { $username = $_COOKIE['ID_my_site']; $pass = $_COOKIE['Key_my_site']; $check = mysql_query("SELECT * FROM member WHERE mid = '$mid'")or die(mysql_error()); while($info = mysql_fetch_array( $check )) { if ($pass != $info['pass']) { } else { } } } //if the login form is submitted if (isset($_POST['submit'])) { // if form has been submitted // makes sure they filled it in if(!$_POST['mid'] | !$_POST['pass']) { die('You did not fill in a required field.'); } // checks it against the database if (!get_magic_quotes_gpc()) { $_POST['email'] = addslashes($_POST['email']); } $check = mysql_query("SELECT * FROM member WHERE mid = '".$_POST['mid']."'")or die(mysql_error()); //Gives error if user dosen't exist $check2 = mysql_num_rows($check); if ($check2 == 0) { die('That user does not exist in our database. <a href=add.php>Click Here to Register</a>'); } while($info = mysql_fetch_array( $check )) { $_POST['pass'] = stripslashes($_POST['pass']); $info['pass'] = stripslashes($info['pass']); $_POST['pass'] = md5($_POST['pass']); //gives error if the password is wrong if ($_POST['pass'] != $info['pass']) { die('Incorrect password, please try again.'); } else { // if login is ok then we add a cookie $_POST['mid'] = stripslashes($_POST['mid']); $hour = time() + 3600; setcookie(ID_my_site, $_POST['mid'], $hour); setcookie(Key_my_site, $_POST['pass'], $hour); //then redirect them to the members area header("Location: member.php"); } } } else { // if they are not logged in ?> <?php } ?> Last edited: 04-May-11 02:56 PM