hypothetical delete customers question

[unn]

I've been developing a little mod to zencart and I've got about 50 or so test accounts that I've made and deleted at various times. I'm going live with the site and I don't need any of these accounts now. So would it be safe for me to do...

DELETE FROM customers WHERE id = all ids
 ALTER TABLE customers AUTO_INCREMENT = 0

followed by a

DELETE FROM address_book WHERE id = all ids
ALTER TABLE address_book AUTO_INCREMENT = 0

Those are just generic queries, I know they aren't right. But mainly I'd like to know if I need to delete in any other locations?

[DrByte]

You need to also handle the related customers_info records and customer_basket records and customer_basket_attributes records.

If you're trying to simply delete *all* customer records, it would be simpler to use "truncate" and the table name, since that also resets the auto-increment counter while deleting all contents.



OR ... you could simply use the built-in function to delete customers, and have it loop thru them all and delete them one by one


Reference docs:
http://www.zen-cart.com/wiki/index.p...atabase_Schema

[zcnb]

OR ... you could simply use the built-in function to delete customers, and have it loop thru them all and delete them one by one

This is exactly what I am looking for. Where can I find more information about this built-in function?

Name of .php file and/or function would be super. Thanks!