PHP/MySQL help

PhilM · November 30, 2006

I'm writing a website for a mate's band. This is a complete page's code below for when they want to delete a gig from the database.

<?php

require_once('../Connections/conn_kk.php');

$giglistid=$_GET['id'];

$sql = "DELETE FROM 'giglist' WHERE id = '$giglistid'";

$result = mysql_query($sql);

//header("Location: giglist_edit.php");

?>

Now, I can't see anything wrong with that, and when I output $sql to the screen using "echo", it gives:

DELETE FROM 'giglist' WHERE id = '2'

...which is right, but it still doesn't actually delete the record. Where am I going wrong. This is a really basic thing that I've done many times before. The biggest problem is that it works on my own server, but when uploaded to the host (Telivo), it just doesn't delete the record. It doesn't give me any errors or anything like that, it just does all of that, igones the delete and goes the "giglist_edit.php" page.

Sorry if this is too geeky for this forum, but I thought I'd check with some seemingly smart people before I whine at Telivo.

Kahnee · November 30, 2006

This post is not viewable to guests.