I created a database focusing on the world's nations,
states, etc. that uses a "parent-child" relationship,
as defined in a table named "family." I'm now trying
to figure out how to query the parent, and it occurred
to me that my tables might not be set up correctly.
If anyone is willing to glance at my screenshots at
http://www.geoworld.org/tables1.gif and
http://www.geoworld.org/tables2.gif, can you give me
your impression? I think the only tables you need to
focus on are "family," "area" and perhaps "type."
For example, the word "France" is found in field
"Name" on table "area." The name of its parent,
"Eurasia," is found in the same field and table, but
their relationship is defined in the table "family."
I posted a rather lengthy question about querying
"Parent1" on a PHP forum at
http://www.phpfreaks.com/forums/index.php?act=ST&f=1&t=36967
As I said, I'm now wondering if my tables are set up
correctly to begin with.
Thanks.
__________________________________
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
http://promotions.yahoo.com/new_mail
