Creating a Product Database for Dreamweaver MX

[antibrandcorp]

Hi, I'm really new to datadriven websites and access

I'm really stuck with all this normalisation and relationships with database structure and wondered if anyone could help.

I need to make a product Database.

Product Name, Product Description, Weight, Price, Size, Colour, Catogory.

NOTE: Not all products have a size or colour, some products are available in more than one colour or size... Help I'm soooo stuck, I dont even know where to start.

Any help would be really cool, many thanks in advance.

I'm using VB-ASP in DMX.

 

[vbkris]

Well for a start first build the HTML form using DW. next do client side validation of the form...

Known is handfull, Unknown is worldfull

 

[antibrandcorp]

How do you do validation?

Doh!

 

[vbkris]

using Javascript. DW is supposed to have some behaviors for that (i have never used them)...

Known is handfull, Unknown is worldfull

 

[antibrandcorp]

What is it meant to Validate?

 

[vbkris]

o.k, this will be one hell of a job...

validate means check whether the user has entered all the details like if in tek-tips if u dont enter ur username it doesnt allow u to login. something like that. i think u must start learning a bit of javascript first for u to understand how it can be done...

Known is handfull, Unknown is worldfull

 

[antibrandcorp]

I understand what validation means, I just dont understand what that has to do with the database design so I can get the right queries

 

[vbkris]

u dont want an incomplete database do u? validation helps in seeing that all the required info in the daabase are filled by the user in the HTML form...

Known is handfull, Unknown is worldfull

 

[antibrandcorp]

Oh right, so the first step is to make a form to update all database?, is that what you mean?

Carl.

 

[lebisol]

validation...
when u get to the docs office thay ask u to 'fill in some forms AND PRINT your name'...why? so they can validate your signature....and collect the "correct" data.
the rest:

http://www.w3.org/MarkUp/

All the best!
(p.s. good luck vbkris)

> need more info?
:: don't click HERE ::

 

[vbkris]

yes, thats the first step. and thanks lebisol...

Known is handfull, Unknown is worldfull