Cannot delete a row with PHP & MySQL

[n0vembr]

dont u think it should be :

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

Having it like this

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

would make the SQL query exactly "DELETE FROM $data[0] WHERE ID IN($data[1])", which obviously would give an error...i think

[Kasracer]

You can have arrays in sql queries like I have just fine. I do it in other queries to update my tables.

dont u think it should be :

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

Having it like this

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

would make the SQL query exactly "DELETE FROM $data[0] WHERE ID IN($data[1])", which obviously would give an error...i think

Tried it with the exact same results

I have no clue what's going on

[n0vembr]

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

[visualAd]

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

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.

[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.

[visualAd]

dont u think it should be :

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

Having it like this

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

would make the SQL query exactly "DELETE FROM $data[0] WHERE ID IN($data[1])", which obviously would give an error...i think

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

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