Hey everybody. So I am just trying to write a script to delete a row in a MySQL database. Unfortunately I seem to have something wrong...even though I don't get any errors.
Here is a snippet of the code on the page to send the request:
echo "<tr><td width='138px' height='104px' valign='middle' rowspan='4'>" .
"<img src='../$amv_thumbnail' border='0' align='center' /></td>" .
"<td>$amv_name</td>" .
"<td>$amv_length</td>" .
"<td>$amv_creator</td>" .
"<td>$amv_studio</td></tr>" .
"<tr><td colspan='4'>$amv_url</td></tr>" .
"<tr><td colspan='4'>$amv_creator_url</td></tr>" .
"<tr><td colspan='4'><div style='text-align: right;'>" .
"<a href='javascript:void(0)' onClick='javascript:sendRequest(\"deleterow.php?id=" . $id . "\", \"viewer\")'>Remove AMV</a></div></td></tr>";
I have checked that the 'id' that was passed was correct. So I know that the code above is working. 'is' is not displayed as a variable above as it isn't directly used in the table. SELECT id, ... FROM amvs...while(list($id,...))
Here is the code from the deleterow.php script:
<?php
$dbc = mysqli_connect('server', 'username', 'password', 'database')
or die('Error connecting to MySQL server.');
if(isset($_GET['id']))
$id = $_GET['id'];
else
die("No ID passed");
$sql = "DELETE FROM amvs WHERE id='$id'";
$result = mysqli_query($sql)
or die('Error Deleting Record');
Echo "AMV Removed Successfully";
include_once 'getamvs.php';
mysqli_close($dbc);
?>
The only message I get (plus the included page) is AMV Removed Successfully. However if I go to my phpMyAdmin the row is still there and it also shows up in the returned query below the message.
Can someone see something that I'm not?