http://qs1969.pair.com?node_id=225520


in reply to Re: Re: Re: How to display all the content of the database?
in thread How to display all the content of the database?

Sorry, I switched in a hurry :)

... however, you got it. It could even be a database that contains products and their parts and services that goes for unknown depth level. But, no matter how deep it goes and what is to be displayed, the script have to display parent entity and all of the tuples of its child entity and then all tuples of child entity (which is parent in this turn) and all of tuples of its child enitities, etc.

It has already been done, using PHP and MySQL, but I'm doing things in Perl.

Replies are listed 'Best First'.
Re: Re: Re: Re: Re: How to display all the content of the database?
by herveus (Prior) on Jan 09, 2003 at 13:00 UTC
    Howdy!

    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

      Well, give me $500 and I'll buy it and then I'll tell you how the problem is solved :)

      PS: for that price you'll get full web system with admin area and lots of other stuff.
        Howdy!

        OK. So are you also having to implement the database itself? Does that give you control over the RDBMS you use on the backend?

        If you get to design the database, you get to make things possible. If you are handed a database to query against, then you can discover the list of tables, hopefully programmaticly. One can hope that the relationships can also be discovered on the fly.

        yours,
        Michael