I want this query to request extension and department from my database. I can make it work with only one of them but not both.
code:
$this_user_ext =$_REQUEST['extension']; <----This line here I need 'department' in it as well.
// sending query
mysql_query("DELETE FROM users WHERE extension = '$this_user_ext'")
or die(mysql_error());
if($_POST['action'])
{
include('maildelete.php');
$extension=$_POST['extension'];
header("Location: index.php");
}
So basically, you want something like:
$this_user_ext = $_REQUEST['extension'];
$this_user_dep = $_REQUEST['department'];
//please escape and/or validate the request values
$query = "DELETE FROM users WHERE "
. "extension = '$this_user_ext' "
. "AND department = '$this_user_dep';";
mysql_query($query) or die(mysql_error());
//please don't use mysql_query(), because it is deprecated