Hi,

(Sorry for my bad English)

I just wrote a php+mysql script that is a Customers Management System. You can see it at:

http://www2.cretaforce.net/~chris/customers

I will fix some bugs and I will sell it for 30$.

If your customer must pays within next 7 days it will show him with green color. If the customer's account expired it will shows him with red color. In other occasions it will show him with black.

You can add/delete/edit customers and also e-mail them.

If someone is interested to buy the final version of the program which will be ready today or tommorow can contact me:

e-mail: chris@cretaforce.net
MSN: coderz2004@hotmail.com

can it auto email as a reminder when a customer is due to expire?
and emails the customer to remind him his account is due to expire?

Yes it can do both of them, just see the mail function in the demo site.

possible to automate this step?

like it auto email the customer 5 days before his account expires and BCC's the owner?

Yes I can do it via a php script that will run via crontab every 5 days.

The final script is ready. The instructions are:

Step 1: Create a mySQL database and give permissions to the user you want
Step 2: mysql -u user database < customers.sql -p
Step 3: Edit config.php
Step 4: Edit mail.inc
Step 5: Use apache authentication for a login/pass

Have a look: http://www2.cretaforce.net/~chris/customers

Contact info:
e-mail: chris@cretaforce.net
MSN: coderz2004@hotmail.com