Hi all

 

I have created my site as .HTML not sure if this was the right thing to do, I have been out of touch with creating websites for serval years now and have never created anything which is interactive to the user.

 

I am now fiddling around with a MySQL database which hold 'products'.

 

How can I create individual product pages for each record in my MySQL database? By only creating one page (if that makes sense). Like Amazon, all information is pulled from a database, they dont manually make each product page, thats what I'm getting at

 

Also how do I get certain products to appear on the homepage?

 

Is it a good idea to hold images such as jpeg files in a MySQL database? If not how would I save the products image?

 

I have tried searching the internet for the answers, I am probably not using the correct termanology.

 

I appreciate any help given

 

Thanks, Dan

I'm no expert but i will have a shot at this. Firstly: Problems with storing images in MySQL, it would probably be best to have the images in a directory on your server and then just 'reference' them via the URL in your database.

 

For dynamic pages you have on page and then have it respond with content based on variables that you pass it. See here for a start. Here is a 'single page' script that i am working on that generates dynamic content based on variables passed to the page via the URL.

 

HTH.