jeeves245 Posted August 3, 2009 Share Posted August 3, 2009 Hey all, I have a table in PHP My Admin with about 150 records. When trying to delete these records, it says "Your SQL query has been executed successfully" but the records are not deleted. Any ideas appreciated (Using 3.1.3.1, Apache/2.2.11 (Win32) DAV/2 mod_ssl/2.2.11 OpenSSL/0.9.8i PHP/5.2.9 MySQL client version: 5.0.51a). Quote Link to comment Share on other sites More sharing options...
fenway Posted August 3, 2009 Share Posted August 3, 2009 Perhaps posting the query would help. Quote Link to comment Share on other sites More sharing options...
jeeves245 Posted August 3, 2009 Author Share Posted August 3, 2009 Perhaps posting the query would help. I'm just checking the boxes and clicking the big red X in PHPmyAdmin. The query it uses is: DELETE FROM `customerDB`.`customer` WHERE `customer`.`customerName` = '' AND `customer`.`address1` = '' AND `customer`.`address2` = '' AND `customer`.`address3` = '' LIMIT 1; Quote Link to comment Share on other sites More sharing options...
fenway Posted August 4, 2009 Share Posted August 4, 2009 I see blank field values... is that intentional? Quote Link to comment Share on other sites More sharing options...
jeeves245 Posted August 4, 2009 Author Share Posted August 4, 2009 I see blank field values... is that intentional? There are blank values in some fields yes. But the query itself is generated by phpmyadmin so I would assume it to be correct? Quote Link to comment Share on other sites More sharing options...
fenway Posted August 10, 2009 Share Posted August 10, 2009 Well, you said 150 records, and I see limit 1? Quote Link to comment 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.