alh

ThnX

Ch0cu3r - ThnX for responding... so I create the view_product_page.php page? what is in it? do I create a MySQL query that gives me the "chocolate-bar" string? it seems like there are 2 different places that the mod_rewrite has to act... 1) when someone clicks on a product link on the site and the URL that is displayed is the nice one like - site.com/view_product_page.php?product=chocolate-bar and 2) when someone gets that nice URL, clicks on it and gets taken to the correct product page is this correct? how does #2 happen? there is no /product/ folder? Page 18 is a page called productPage.php that's a page that does a MySQL query based on the passed ID and displays the formatted product information.

I'm a complete newbie with mod-rewrite, but I've been programming php and javascript for many years. I have a client with a store that has 1,000+ products with more being added/changed daily. each product page is generated dynamically using php & mySQL and looks like this: http://www.mysite.com/store/?Page=18&Product_ID=3001424 needless to say I don't want to put in mod_rewrite rules for every product independently. I don't even know where to start with this. it looks as if the mod_rewrite in .htaccess doesn't get generated automatically. so how do sites like my clients or even bigger sites deal with this? ThnX

I have a database that has a table called SIZE with the following fields: item_number size_1 size_2 size_3 size_4 size_5 the available sizes may use any number of the fields. if any one is not used, it is NULL. I need to iterate through them to put those that are NOT NULL in a select statement in a form so the user can choose from the ones currently available. I seem to be hitting a brain freeze on this one. can anyone help me with this? thanks in advnce, ALH