Hi all

Web site goal to create a website for selling products for men and women. I
have a total of 35 manufacture's and over a hundred products total. I would
also like to have and news column and item of the week links on the home
page

My inital thought would be to create a database in mysql using phpmyadmin. That would include
the product manufacture, product image, product price and product
description. And when a user of the site would click on the example for men
or for women link. It would then load a product manufacture list page and
when the manufacture name or link is clicked it would then load the
coresponding product images, price points and product description for each
product in a nice layout in the middle of the page.

What I dont understand about the database. Is how do I go about getting all
this to work and getting the correct data into the page. How would I for
example I will say I only have 3 product manufactures instead of 35. Each
manufacture has and total of 5 products each. The example manufactures are
Tommy hilfigure, Calvin klien and Obsession. What I dont understand is that
when a user clicks on the obsession link how will it know to load the
obsession page of products with the following descriptions product image,
price and description. Do I need to create a different page for each
manufacture with a total of 35 or more pages. Or Would I need to create for
example a product page with a dynamic data table with cells that will hold
areas for the product image, product description and the product price and
use that as a template page and tell every manufacture link to goto that
product template page inside the web site. Whew I am so confused. I know I need to
read up on mysql databases (not a problem). But I see different tutorials at
macromedia.com that show you how to insert record sets of data from a
database you have created either in ms access or mysql. To give you a
visualization of the product page I want to create when a product
manufacture link is clicked. Something that resembles the Macromedia
Dreamweaver Exchange page. My thought would be to create a table like that
then insert the records into the table but is this the correct way or am I
way off.

About Pay Pal extension in dreamweaver
I know there are two extension for paypal for dreamweaver. One is a single
item purchase the other is and add to cart button. But I have not got the
slightest idea how to implement the paypal extension features if I have to
create a database for the products as I described in the paragraph above.

News and Item of the week

Goal to have a product image 65x65 pixels displayed with a brief description
next to it

I know that this part of the site will change from time to time so I was
thinking it must be database driven. Any ideas how I would go about this. Or
my inital way of doing it would be to create the table and cell in the layout
and just change the item and description in the dreamweaver layout page
Any help apreaciated

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> My inital thought would be to create a database in mysql using phpmyadmin<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

i dont use it, so cant help ya there

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> What I dont understand about the database. Is how do I go about getting all this to work and getting the correct data into the page<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

thats setup when you create the record in your database, each item gets an ID number, so like this page url for example (topicID is 26706).

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> Do I need to create a different page for each
manufacture with a total of 35 or more pages<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

NO, thats why its in a database <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>Or Would I need to create for example a product page with a dynamic data table with cells that will hold areas for the product image, product description and the product price and use that as a template page and tell every manufacture link to goto that product template page inside the web site. <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Now your getting there <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> Something that resembles the Macromedia Dreamweaver Exchange page<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

I think this is built in flash & cold fusion, but dont quote me.

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>My thought would be to create a table like that
then insert the records into the table but is this the correct way or am I
way off.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

no, your spot on. just when your adding your records, you only need to add 1, and then put the server behaviour "repeat region" on the table and it will display all the records <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

once you have the hang of it, you can filter the records for each company, product, category, whatever you wish.

best of luck.

Regards,
Dave

[DWMX 2004]|[FlashMX 2004 Pro]|[Studio MX 2004]|[SQL]|[Access2000/2002]|[ASP/VBScript]|[XP-Pro]
If you like online gaming, please register @ www.nova-multigaming.com

Hey UltraDav thanx for the responses to let me know I was on the right track