physaux Posted October 10, 2009 Share Posted October 10, 2009 <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!! Quote Link to comment https://forums.phpfreaks.com/topic/177238-solved-php-mysql_query-delete-problem-simple-but-idk-help-plz/ Share on other sites More sharing options...
mikesta707 Posted October 10, 2009 Share Posted October 10, 2009 $connection is a mysql connection resource. not a db name. try just doing DELETE FROM users WHERE ... Quote Link to comment https://forums.phpfreaks.com/topic/177238-solved-php-mysql_query-delete-problem-simple-but-idk-help-plz/#findComment-934528 Share on other sites More sharing options...
physaux Posted October 10, 2009 Author Share Posted October 10, 2009 Awesome thanks alot i got it working Quote Link to comment https://forums.phpfreaks.com/topic/177238-solved-php-mysql_query-delete-problem-simple-but-idk-help-plz/#findComment-934529 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.