Hi everyone,
I'd like to know how you would set up the following:
I've set up a MySQL database with 600 products. I set it up where each
product belongs to a category. However, now we want to take it further
where different products can now belong to more than 1 category.
How would you create
PROTECTED]
Sent: Thursday, November 07, 2002 7:51 PM
Subject: [PHP-DB] Structure Question...
Hi everyone,
I'd like to know how you would set up the following:
I've set up a MySQL database with 600 products. I set it up where each
product belongs to a category. However, now we want to take
Third choice, definitely. And aren't you glad your data is sufficiently
normalized that this is a no-brainer!
Cheers - Miles Thompson
At 12:51 PM 11/7/2002 -0600, Doug Coning wrote:
Hi everyone,
I'd like to know how you would set up the following:
I've set up a MySQL database with 600
You would want 2 3.
You should create 3 tables, one for products, one for categories and one
to relate the two. You should only store ID numbers that relate to
products and categories.
On Thursday, November 7, 2002, at 01:51 PM, Doug Coning wrote:
Hi everyone,
I'd like to know how you would
I thought that it was good db design to have no repeating data in your db but
to use a relationship instead?
Jord
On Tuesday 27 March 2001 14:42, you wrote:
Jord,
I don't see quite why you should want to use two tables, you can easily put
all the information in one table and have one
Why don't you just store the file names in a db?
iets much easyer
Hi,
I want to keep filenames of different kinds of media(real sudio, qt, mp3)
for
articles in a db table. Would it be best to store each kind of media in a
different table like one table for real audio, one for quicktime,
I am.
Jord
On Tuesday 27 March 2001 14:06, you wrote:
Why don't you just store the file names in a db?
iets much easyer
Hi,
I want to keep filenames of different kinds of media(real sudio, qt, mp3)
for
articles in a db table. Would it be best to store each kind of media in a
are able to
select over the filetyp criteria!!
Stefan Siefert
-Ursprngliche Nachricht-
Von: Jordan Elver [mailto:[EMAIL PROTECTED]]
Gesendet: Dienstag, 27. Mrz 2001 14:38
An: PHP Database Mailing List
Betreff: [PHP-DB] Structure Question
Hi,
I want to keep filenames of different kinds
