Hello All,
I have a product database. In that database there are several tables
dealing with individual products.
I am wanting to set up an editProduct and a productInfo page. For the
bulk info, I am fine.
For the product options, I need some guidance.
I have 4 tables dealing with the option
On 30 April 2010 12:02, Karl DeSaulniers wrote:
> Hello All,
> I have a product database. In that database there are several tables dealing
> with individual products.
> I am wanting to set up an editProduct and a productInfo page. For the bulk
> info, I am fine.
> For the product options, I need
Thanks Peter.
So what is the logic behind foreign keys? Why use them?
Thx.
Karl
Sent from losPhone
On Apr 30, 2010, at 5:09 AM, Peter Lind wrote:
On 30 April 2010 12:02, Karl DeSaulniers wrote:
Hello All,
I have a product database. In that database there are several
tables dealing
with
On 30 April 2010 12:26, Karl DeSaulniers wrote:
> Thanks Peter.
> So what is the logic behind foreign keys? Why use them?
Constraints. When using, for example, the InnoDB engine in MySQL, you
can set foreign key fields on tables. These ensure that your record
will always be bound to a proper reco
On 30 April 2010 13:41, DZvonko Nikolov wrote:
>
> Hi,
>
> don't confuse the guy.
Don't talk down to the man. He asked questions and got usable answers
including links to where he could find more info.
--
WWW: http://plphp.dk / http://plind.dk
LinkedIn: http://www.linkedin.com/in/plind
Flickr:
No, please confuse me. I need to know this stuff.
@Peter thanks for that introduction to foreign keys. Since my
productoptions table is based off of items in products, optionGroups
and options, would I use foreign keys for this?
@DZvonko Thanks for trying to protect me, but I am a big boy.
@David,
Thanks for your reply.
The idea was based off the WebAssist E-Commerce Database file they
gave out a while ago.
So, I did not set up the database file necessarily, just adopted and
modified.
This is how they had it set up. Not that I have to keep that
structure necessarily, but I did
To elaborate a little more,
In essence, the options and the option groups will be added to the
database by an admin,
the products will be added by admins and employees alike.
When an employee goes to add a product, I want them to be able to
choose from a dropdown
or a table with names and r
