macromedia flash sitedesign: Hello

I am working on a project right now that requires me to make a dynamic flow chart from a database. The problem is that it needs to be change by multiple different people. Some of them want the ability to just drag and drop the boxes in the flash a area which will then atomically link to above that it is closest to, if possible have the lines appear to the one that it would connect to as they are dragging the item. After the item is attached they will need to be able to type a description into the box. Also they need to have the ability to remove an item and all sub items will automatically be removed. After they submit the changes it will be going into a MySQL database

I have come to the concussion so far that probably the best way to display this is to get the content from the database with PHP and then create a XML file (if you have a better suggestion for this please tell me). One of the problems I am trying to figure out before I start it is how to get the database to update the items that where already there, that may have changed as well as insert the new ones or remove a item and all of it sub items.

Does any body have any suggestions?

Create your PHP page that is passed parameters (if you need them) and have
it request data from the database and when it gets the data back it can
manipulate it a little and dump the data out as an XML string. In ASP.NET
it's very simple. I just grab a dataset object from the database and
convert to XML and then do a Response.Write to dump all the xml as a string.
Then you just load that PHP or ASP page using XML.load from Flash. Flash
doesn't know the difference, it just knows it gets back XML which is what
it's looking for static or not.

--
Shane Elliott
www.timberfish.com
www.friesontheside.com


[quoted text, click to view]
flow chart from a database. The problem is that it needs to be change by
multiple different people. Some of them want the ability to just drag and
drop the boxes in the flash a area which will then atomically link to above
that it is closest to, if possible have the lines appear to the one that it
would connect to as they are dragging the item. After the item is attached
they will need to be able to type a description into the box. Also they
need to have the ability to remove an item and all sub items will
automatically be removed. After they submit the changes it will be going
into a MySQL database
[quoted text, click to view]
this is to get the content from the database with PHP and then create a XML
file (if you have a better suggestion for this please tell me). One of the
problems I am trying to figure out before I start it is how to get the
database to update the items that where already there, that may have changed
as well as insert the new ones or remove a item and all of it sub items.
[quoted text, click to view]