snowchild

ok .. sorry I asked. I wont bother you again

Oh I see .. you are using the .htAccess file to do redirects <IfModule mod_rewrite.c> RewriteEngine on # For sales: RewriteRule ^shop/sales/?$ sales.php # For the primary categories: RewriteRule ^shop/([A-Za-z\+]+)/?$ shop.php?type=$1 # For specific products: RewriteRule ^browse/([A-Za-z\+\-]+)/([A-Za-z\+\-]+)/([0-9]+)$ browse.php?type=$1&category=$2&id=$3 # For HTTPS pages: RewriteCond %{HTTPS} off RewriteRule ^(checkout\.php|billing\.php|final\.php|admin/(.*))$ https://%{HTTP_HOST}/$1 [R=301,L] </IfModule> Problem is I have installed this on my live server in a sub dir, and I believe the main .htAccess redirects are overruling these.

Well I am still working through the ebook and trying to get a handle on how things are done. I downloaded the scropts and installed the coffee script on my server this morning. I got an sql error when I imported the sql.sql file. SQL query: -- ----------------------------- -- Stored Procedures -- -- ----------------------------- DELIMITER $$ CREATE PROCEDURE select_categories( TYPE VARCHAR( 6 ) ) BEGIN IF TYPE = 'coffee' THEN SELECT * FROM general_coffees ORDER BY category; ELSEIF TYPE = 'other' THEN SELECT * FROM non_coffee_categories ORDER BY category; END IF ; END$$ MySQL said: #1304 - PROCEDURE select_categories already exists Any idea why this happening ? it created the following tables carts customers general_coffees non_coffee_categories non_coffee_products orders order_contents sales sizes specific_coffees transactions wish_lists Now when I run the Index.php file I am getting the main page, without any images, and the links to the product pages do not work. Seems they are looking for a DIR called /shop which I do not find anywhere in the HTML dir structure .. Am I missing something ?

Hi Larry I don't see much reference to unregistered users in regards to moving their data through the checkout. With registered users we can collect order data in the DB, then serve them up their billing/shipping address during checkout, but for unregistered users that don't want to create an acoount, how to handle the order data? I assume we are using the $_SESSION vars to maintain a $data array of items added to the cart, but when and if they make the checkout purchase, how and where are we going to add the info to the DB without creating a huge table of "unregistered user" data? The products we sell are all drop shipped or custom made and we require a lot of variables (10 or more) for each product ordered. Some of those vars include text and images. The way we handle it right now is using cookies to maintain data through checkout, No Database, the order is processed with a cgi to GpG encryption, then an encrypted copy is stored on the server and also Emailed to us for decryption and processing on this end. In other words we do not use a gateway. While this system has served us well these past several years, and appears to be very secure, I would like to recode the site in PHP and MySql to take advantage of the power of databases which will be able to provide more features to the customer. On the other habd, I would still prefer to do the encryption rather than a geateway. The problem is really how to retain order data without bloating the DB ? Thanks