REQUEST查询多个字段

Question

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");
}

Answer 1

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