expense_delete.php

<?php
    $id = filter_var($_REQUEST['id'], FILTER_VALIDATE_INT);
    $sql = "SELECT * FROM `mod_expenses` WHERE `id` = $id LIMIT 1";
    $exec = mysql_query($sql);
    if(mysql_num_rows($exec) > 0) {
        $sql = "DELETE FROM `mod_expenses` WHERE `id` = $id LIMIT 1";
        if(mysql_query($sql)) {
            header("Location:$modulelink&expense=list&msgid=11");
        } else {
            header("Location:$modulelink&expense=list&msgid=12");
        }
    } else {
        header("Location:$modulelink&expense=list&msgid=13");
    }
    
?>