从表中删除*不起作用[关闭]

我正在尝试删除all rows从表中但它不起作用。当我做echo $mydb->error;它给了我以下内容：

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROM messages where from_user = ? and id = ?'

     $user = 'currentuser';
 if (isset($_POST['delete'])) {
 if(!empty($_POST['id'])){
 $id =  $_POST['id']; 


 $mydb = new mysqli('localhost', 'root', '', 'database');
 $stmt = $mydb->prepare("DELETE * FROM messages where from_user = ?  and id = ? ");
 echo $mydb->error;
 $stmt->bind_param('ss', $user, $id);
 foreach  ($_POST['id'] as $id) {
$stmt->execute();
}
echo"The Message deleted permanently";
}
}

它应该是

$stmt = $mydb->prepare("DELETE FROM messages WHERE from_user = ?  AND id = ? ");

我会很感激使用mysqli_*函数而不是已弃用的函数mysql_*

另外，不应该有*用于删除；这不是正确的语法。

参考：

• https://dev.mysql.com/doc/refman/5.0/en/delete.html https://dev.mysql.com/doc/refman/5.0/en/delete.html

The *语法与 SELECT 结合使用：

• https://dev.mysql.com/doc/refman/5.0/en/select.html https://dev.mysql.com/doc/refman/5.0/en/select.html