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). Link to comment https://forums.phpfreaks.com/topic/168605-deleting-records-from-phpmyadmin/ Share on other sites More sharing options...
fenway Posted August 3, 2009 Share Posted August 3, 2009 Perhaps posting the query would help. Link to comment https://forums.phpfreaks.com/topic/168605-deleting-records-from-phpmyadmin/#findComment-889982 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; Link to comment https://forums.phpfreaks.com/topic/168605-deleting-records-from-phpmyadmin/#findComment-890133 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? Link to comment https://forums.phpfreaks.com/topic/168605-deleting-records-from-phpmyadmin/#findComment-890913 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? Link to comment https://forums.phpfreaks.com/topic/168605-deleting-records-from-phpmyadmin/#findComment-890988 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? Link to comment https://forums.phpfreaks.com/topic/168605-deleting-records-from-phpmyadmin/#findComment-894751 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.