[SOLVED] PHP MYSQL_query DELETE problem... simple but idk.. help plz!!

[physaux]

<php?
$result = mysql_query("DELETE FROM ".$connection.".users WHERE users.email = '".$email."'");
?>

i am getting an error:

Database query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'id #5.users WHERE users.email = ''' at line 1

 

I know it is not my variable's fault, because all my other queries work well. Example a working one:

$result = mysql_query("INSERT INTO users VALUES('".$language."', '".$email."', '".$password."', '".$ip."')");

what is going on? I think the problem is that i am trying to send the " sign. How do i fix that? Thanks!!

[mikesta707]

$connection is a mysql connection resource. not a db name. try just doing DELETE FROM users WHERE ...

[physaux]

Awesome thanks alot i got it working