prateekshaweb

Hi you only encrypt the password using md5....and store the md5 string in the database....the search sql would be like $username = $_POST['username']; $password = md5($_POST['password']); $query = "SELECT * FROM users WHERE username = $username AND password = $password";

Hi Try using brackets..and remove the quotes near $get1 $result = mysql_query("SELECT id FROM agents WHERE (lft BETWEEN '$lft' and '$rgt') AND (autoshipdate BETWEEN '$unistart' and '$uniend') ORDER BY id desc LIMIT 0,$get1") or die(mysql_error());

Hi you must store the user details in a session. create an object called user and store the access id (aid) to manager if managaer and employee if employee..... make the user login before using the search page.... this way you will know that the user is manager for the …