So the database is already implemented in MySQL? It would have been helpful to mention that earlier. :)

I don't know MySQL well enough to know how it does referential integrity; I'm a Sybase guy being turned into an Informix guy.

How does the PHP code discover children? You should probably be able to use the same metadata it uses. It can't know any more than your Perl script can.

yours,
Michael