how would i go about setting up an order page and a checkout page - both in database design and page design?

I want it to be able to list all the products a user has added to thier own personal profile and for them to be able to select which items to order (and then be able to view them on a seperate order form), which to remove, and how many to order etc

im stuck on how to design a database for this.

PLEASE dont point me towards the extreme ultradev tutorials...it was them that got me confused in the first place...

im looking for some original ideas or something that has worked in the past for somebody.

well, this is off the top of my head, but I would go with the 4 table design (not counting all of your product tables and whatnot)...

-User table (userID, name, address, etc.)
-Profile (userID, productID)
-orders (orderID, userID, dateOrdered)
-orderdetails (detailID, orderID, productID)

then that way, the user can have as many Items in his "profile", and then create an order based on those items. he can then edit, delete, etc. the order details, without affecting his profile.

hope that helps,

Joel Martinez

----------
Is this thing on?....

<center>&gt;&gt;&gt;&gt; TEXT DELETED BECAUSE THE USER WAS MISBEHAVING &lt;&lt;&lt;&lt;

&gt;&gt;&gt;&gt; User received a warning email. &lt;&lt;&lt;&lt;

&gt;&gt;&gt;&gt; UDzone Admin &lt;&lt;&lt;&lt;</center>

Edited by - joelmartinez on 07/20/2001 17:01:04

Well Paleface, you seem like an ignorant arsehole, why dont you go and learn something rather than ask others for their help, only to abuse the help they give.

is it possible for you to learn?

Original ideas you say? In database design, original ideas are not the be all and end all, the four table system is clean, simple and easy to setup, tried and tested.

Why not see if your scratched ass has anything better to add.

LEED

<center>&gt;&gt;&gt; Topic locked by Moderator because the original poster was misbehaving. &lt;&lt;&lt;</center>

Waldo Smeets - www.UDzone.com Webmaster
------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
------------------------------------------