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
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
