Deleting from database

[Anon]

I am using this to delete from a database but it does not seem to be working.

$sql="DELETE FROM 'events' where topic ='$topic'";

Is this right?

[Anon]

That is a correct query, but it might not be correct in terms of your table structure. The query you have assumes you have a table called "events" that contains a field called "topic." If that is the case, then the problem likely lies in your $topic var. Are you sure it has a value?

Also, what you have is simply forming the query statement. Are you actually executing the statement with something like this: mysql_query($sql);?

[Anon]

Yea i have all that, I still cant get it to work.

[Anon]

Echo out your sql statement to make sure it has a value for the $topic var.

echo "sql = $sql";

If the $topic does have a value, are you sure there are entries that match that value?

[Anon]

Remove the apostrophes around the tablename

$sql="DELETE FROM events where topic ='$topic'";