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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
