I have the following code in a page of mine, and for some reason it doesn't delete from the database, but if I run the query direclty in MySQL Front it does work.

I have ripped all the stuff out that doesn't matter to this query and so it's easier to see.

If it's any help, the $id is an auto_increment number


Many Thanks
Ian Gunter


PHP Code:
<?
//uploader.php
function delete_file() {
?><table width="615" border="0" cellspacing="2" cellpadding="2">
        <tr>
            <td><p><strong>File Deleted</strong></p></td>
        </tr><tr>
            <td><hr color='#333333' size='1'></td>
        </tr>
        </table>
        <?
        
// create SQL statement
        
$sql "DELETE FROM files WHERE id=$id";

        
$results mysql_query($sql);

        
index();
}
function 
index() {
?><table width="615" border="0" cellspacing="2" cellpadding="2">
        <tr>
            <td width='**'><p><strong>Filename</strong></p></td>
            <td width='55' align="center" colspan="3"><p><strong>actions</strong></p></td>
        </tr><tr>
            <td colspan='2'><hr color='#333333' size='1'></td>
        </tr><?
        
// create SQL statement
        
$sql "SELECT * FROM files";

        
// execute SQL query and get result
        
$sql_result mysql_query($sql)
            or die(
"Couldn't execute query.");

        
// format results by row
        
while ($row mysql_fetch_array($sql_result)) {
            
$id $row["id"];
            
$filename $row["filename"];

        
// format html output
        
echo "<tr>
            <td width='**'>
$filename</td>
            <td width='55' align='center'><a href=\"?action=delete&id=
$id\" onclick=\"return confirm('Are you sure you wish to delete this file?')\"><img src='images/but-delete.gif' width='50' height='15' border='0'></a></td>
        </tr>"
;
        }
        
?><tr>
            <td colspan='2'><hr color='#333333' size='1'></td>
        </tr><tr>
            <td width='**'><p></p></td>
            <td width='55' align='center'><a href='?action=add'><img src='images/but-add.gif' width='50' height='15' border='0'></a></td>
        </tr>
        </table>
<? require('auth.inc'); ?>
<html>
<head>
    <title>Mando Group - Control-C</title>
    <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
    <link href="styles/control_c.css" rel="stylesheet" type="text/css">
</head>

<body>

<? include ('../includes/connect.inc'); ?>

<table width="738" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
    <td><strong>Downloads</strong><br>
        <span class="textsmall">Add a new download</span></td>
</tr><tr>
    <td align="center"><?
        
if($action == 'upload'upload_file();
        else if(
$action == 'add'upload_form();
        else if(
$action == 'delete'delete_file();
        else 
index();
    
?></td>
</tr>
</table>
</body>
</html>