I have been trying to create a functionality which allows users to delete multiple entries from database, I have been working on this for a while now but cant get my head around it, can u please tell me what im doing wrong here?
thanks in advan
[php]<?php
include ‘global.php’;
$session_username = $_SESSION[‘username’];
if ($_POST[‘login’])
{
//get form data
$username = addslashes(strip_tags($_POST[‘username’]));
$password = addslashes(strip_tags($_POST[‘password’]));
if (!$username||!$password)
echo “Enter a username and password”;
else
{
//log in
$login = mysql_query(“SELECT * FROM agents WHERE username=’$username’”);
if (mysql_num_rows($login)==0)
echo “No such user”;
else
{
while ($login_row = mysql_fetch_assoc($login))
{
//get database password
$password_db = $login_row['password'];
//encrypt form password
$password = md5($password);
//check password
if ($password!=$password_db)
echo "Incorrect password";
else
{
//check if active
$active = $login_row['active'];
$email = $login_row['email'];
if ($active==0)
echo "You haven't activated your account, please check your email ($email)";
else
{
$_SESSION['username']=$username; //assign session
header('Location:my.php');
}
}
}
}
}
}
else
{
if (isset($session_username))
{
echo “You are logged in, $session_username. , Log out”;
}
else
{
echo "
Password:
}
?>[/php]