Re: delete message function
| From: | Chris Stinemetz | Date: | Tue, 14 Jun 2011 05:50:39 +0000 |
| Subject: | Re: delete message function | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-47851@lists.php.net to get a copy of this message | ||
On Tue, Jun 14, 2011 at 12:31 AM, Chris Stinemetz
<chrisstinemetz@gmail.com> wrote:
> I created the below delete function, but it doesn't seem to be working
> correctly. When I enter the correct password it get my echo "Incorrect
> Password Did not Delete!" When I leave the password blank the message
> will delete from mysql table.
>
> Am I missing something??
>
> Thanks in advance,
>
> Chris
Sorry. I left out the call to the function. Below is the whole snippit
for the function and call.
function delete_message(&$msg) {
extract($msg, EXTR_PREFIX_ALL, 'row');
$result = mysql_query("SELECT ID FROM mbmsgs WHERE Parent = $row_ID;");
while ($row = mysql_fetch_array($result)) {
delete_message($row);
}
mysql_query("DELETE FROM mbmsgs WHERE ID = $row_ID;");
}
$result = mysql_query("SELECT Title, Password FROM mbmsgs WHERE ID
= {$_REQUEST['Msg']};");
if (!$result) exit;
if (!mysql_num_rows($result)) exit;
extract(mysql_fetch_array($result), EXTR_PREFIX_ALL, 'msg');
if (isset($_POST['Password'])) {
if (sha1($_POST['Password']) != $msg_Password) {
echo "Incorrect password did not delete!";
exit;
}
$result = mysql_query("SELECT ID FROM mbmsgs WHERE Parent =
{$_POST['Msg']};");
while ($row = mysql_fetch_array($result)) {
delete_message($row);
}