Re: Need MySQL management tool recommendation

pdt256 wrote: 
Anyone know of a management tool that will allow the expanding of
one-many relationships in individual tuples of a table? Much like msoft
access but in a web based format. I've created a simple php script that
will read a database and do this simply, but I don't want to put any
more effort to reinvent the wheel if I don't have to. It would be nice
to have rollover effects that would reference any table that has a
foreign key that references the current primary key in a table row. I
think access implements a plus/minus tree for one-many relationships.
Hope that explains it...

-JI


Its not with rollover effects but it relate the data of many tables using tables naming (exemple letter and letter_article and putting id_letter into letter_article table)

It means that my engine generate related forms so that when you click on a letter, you get a list of articles that relate to this letter and a form to add a new one.

Then you get a simple layout and all the forms needed to add/delete/edit and the menu needed to navigate between the datas.

http://www.phpbackend.com/create_database.php
For more info on integrity constraint of mysql:
http://www.phpbackend.com/one_to_many.php

Nadine St-Amand
nadine@xxxxxxxxxx
info@xxxxxxxxxxxxxx

.