Re: delete message function

[Chris Stinemetz <chrisstinemetz@xxxxxxxxx>]

On Tue, Jun 14, 2011 at 12:31 AM, Chris Stinemetz
<chrisstinemetz@xxxxxxxxx> 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);
        }

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php