From: David Blomstrom (david_blomstromyahoo.com)
Date: Thu Jul 01 2004 - 21:12:55 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

And here's a follow up question...

After looking at my database from a fresh perspective,
I'm now thinking of combining tables "area" and
"family" into a single table.

If I do that, it would make life so much simpler if I
had TWO name fields, like this:

ID | Name | ParentID | Parent Name
--------------------------------------------
az | Arizona | us | United States
us | United States | kna | North America
jpn | Japan | keu | Eurasia

I could then slap a $mycode = 'az" on a page and
easily fill in its name and the name of its parent
without fiddling with queries, joins, unions, etc.

I know that duplicating names in two fields isn't the
most elegant solution, but would create any major
problems?

Thanks.

                
__________________________________
Do you Yahoo!?
Read only the mail you want - Yahoo! Mail SpamGuard.
http://promotions.yahoo.com/new_mail

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]