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
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 products
: <[EMAIL 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 bel
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
ED]]
> Gesendet: Dienstag, 27. März 2001 14:38
> An: PHP Database Mailing List
> Betreff: [PHP-DB] Structure Question
>
>
> 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
u are able to
select over the filetyp criteria!!
Stefan Siefert
-Ursprüngliche Nachricht-
Von: Jordan Elver [mailto:[EMAIL PROTECTED]]
Gesendet: Dienstag, 27. März 2001 14:38
An: PHP Database Mailing List
Betreff: [PHP-DB] Structure Question
Hi,
I want to keep filenames of different kin
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
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 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 co
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, one for
mp3. Or, would it better to store them all in the same table but
10 matches
Mail list logo