Sublime directory Surf the web anonymous Pagerank Monitor


Empty Customers Database

gjv
Wed 10 May 2006, 09:40 pm GMT +0200
Hi Olaf, as first : THANKS for the great db cart script you made. i really appreciate. what i dont get (please explain) is how can i work with an EMPTY customer db? how do i use the script for NEW clients....

1: yes i am using example db

Thanks for your help!

olaf
Wed 10 May 2006, 09:43 pm GMT +0200
Hi Olaf, as first : THANKS for the great db cart script you made. i really appreciate. what i dont get (please explain) is how can i work with an EMPTY customer db? how do i use the script for NEW clients....

Thanks for your help!
Hello,

are you using the example database? just empty the customer table?


gjv
Wed 10 May 2006, 09:44 pm GMT +0200
Hi Olaf, yes i emptyed the customer table, but than the programm does not INSERT the new data into all db's, in plus no EMail is sent to the clients who ordered...THANKS for your help!!!

olaf
Wed 10 May 2006, 09:54 pm GMT +0200
Hi Olaf, yes i emptyed the customer table, but than the programm does not INSERT the new data into all db's, in plus no EMail is sent to the clients who ordered...THANKS for your help!!!

yes, you're right there are no functions to add customer to the database (because the class its a shopping cart not a membership management application)

You can do two things:
build some simple forms to insert the customer data via the web
or try this class: http://www.finalwebsites.com/snippets.php?id=10

the same is for the products, there is no CMS to admin the products. My first idea was to write a class to use with an existing database

gjv
Wed 10 May 2006, 11:28 pm GMT +0200
one more question olaf...i found this code in your class, wich actually should do what i was asking for (empty customer db -> fill in new data:

$sql_new = sprintf("INSERT INTO %s (customer, order_date) VALUES (%d, NOW())", ORDERS, $customer);

is that working?
thanks!

olaf
Wed 10 May 2006, 11:56 pm GMT +0200
one more question olaf...i found this code in your class, wich actually should do what i was asking for (empty customer db -> fill in new data:

$sql_new = sprintf("INSERT INTO %s (customer, order_date) VALUES (%d, NOW())", ORDERS, $customer);

is that working?
thanks!

NOOO!

thats the table used for the orders ;)

Archive for SMF v1.00 by N.P. Valid XHTML 1.0 Transitional