Description: ------------ Joining on a table that has a field name that is the same as the current table's causes overwriting of that field's value. For instance, if you have a table named "person" with a field called "name" and a foreign key "group_id" which links to the table "group" which has a field "name", the name field will have the group's name. This *may* not be a bug as I don't know how it could be "fixed" except to have a sub-object....which is what getLinks() does. Reproduce code: --------------- This is the same code as bug 404 (which I just posted). If you add an entry in table, add an entry in music, then add a link in media_music between them, this happens to the length and title fields. http://www.reversefold.com/~papercrane/brokenJoin.tbz2

this is what selectAs is for. http://pear.php.net/manual/en/package.database.db-dataobject.db-dataobject.selectas.php