Cannot delete a row with PHP & MySQL

[Geert]

I think you're forgetting there have to be quotes round the string in the query.
So I think it's like this:

$result = mysql_query("DELETE FROM '" . $data[0] ."'  WHERE ID IN '" .$data[1] . "'");

I added the single quotes... (if ID is a number in your database, you can delete the single quotes there)

I hope it works, it's my first post here on the forum, and i just know the basics of PHP/MySQL, so don't shoot me if I'm wrong.

[Kasracer]

did u try manually executing the statement in a query analyzer tool?

Ran the same statement in PHP Admin and it worked fine.

You need to use urly brackets to enclose arrays:
{ }

$result = mysql_query("DELETE FROM {$data[0]} WHERE ID IN({$data[1]})");

What? I have several statements which alter rows and insert rows with arrays and they work fine without brackets. Why would delete require them? I'll try it just to double check but I don't understand that.

Use echo() to output the query text an ensure it is what you expect. Then try n0vemberssuggestion of executing that exact text on the command line.

Havn't had the chance of using echo or print. I'm going to give this a try later but it seems the issue is specifically with the sql query

I think you're forgetting there have to be quotes round the string in the query.

Shouldn't matter and I've tried that anyway.