Add addition where clause in MySQL PHP

Question

I have the following clause

$curSong = $wpdb->query("DELETE FROM ".$wpdb->prefix . "current_requests WHERE id='".$_POST['remove']."'");

and id like to add where page_id = $postid to the WHERE clause

simple I know but its just the syntax I am a little unsure of

Thanks

Henry

Answer 1

You mean this?

$query = sprintf("DELETE FROM %scurrent_requests WHERE id='%s' AND page_id='%s'", $wpdb->prefix, $_POST['remove'], $postid);
$curSong = $wpdb->query($query);

You can add more conditions to the where clause using "AND" operator.

Answer 2

$curSong = $wpdb->query("DELETE FROM ".$wpdb->prefix . "current_requests WHERE id='".$_POST['remove']."' AND page_id='$postid'");

Answer 3

you can write sql command like
Delete FROM Table where id=123 AND page_id=789 AND route_id=567

as much as you want, you can add more conditions using 'AND' logical       
operator.

if it helps you mark it as answered.

Answer 4

Modify your code...

Validate the user value to prevent SQL injection

Use htmlspecialchars() or htmlentities() by

$remove= htmlspecialchars($_POST['remove']);
$curSong = $wpdb->query("DELETE FROM ".$wpdb->prefix . "`current_requests` WHERE `id`='$remove' and `page_id` = '$postid'");

Note: You can add many condition by using and or Operator...