mysqli DELETE ahref not functioning

scadoo

New Member
I have a Delete link listed beside all $rows, when I mouse over them they reflect the correct id for deletion, however, when I click DELETE I get redirected to phpfile.php?id=4, for example, and nothing is deleted, no errors are posted.\[code\] while ($row = mysqli_fetch_array($r,MYSQLI_ASSOC)) { echo '<tr><td align="left">' . $row['title'] . '</td><td align="left">' . $row['genre'] . '</td><td align="left">' . $row['length'] . '</td><td align="left">' . $row['created'] . '</td><td align="left">' . $row['views'] . '</td><td align="left">' . "<a href='http://stackoverflow.com/questions/10544496/newwriter_profile.php?id={$row['upload_id']}'>Delete</a></td>" . '</tr>'; } echo '</table>'; // Close the table\[/code\]the remainder of the code, existing on the same page\[code\]if(isset($_GET['id'])) {// Get the ID$id = intval($_GET['upload_id']);require_once ('../mysqli_connect.php'); //Connect to the db $delquery = " DELETE FROM upload WHERE upload_id = {$id}"; $done = @mysqli_query ($dbc, $delquery); // Run the query if($done) { // Make sure the result is valid if (mysqli_num_rows($done)==1) { echo 'Record Deleted'; } else { echo 'error - delete failed'; } // Free the mysqli resources @mysqli_free_result($result); } else { echo "Error! Query failed:" .$mysqli_error($dbc); } mysqli_free_result($done); mysqli_close($dbc);}\[/code\]if I can solve this bug I will solve a similar bug except with a Download function.thanks in advance.
 
Back
Top