Hi I’m building a Flash website with database information with php>mysql>xml>Flash mx 2004. I’m having some major problems!
I need to retrieve information of different tables in mysql, and was worried about performance issues.
[COLOR=Navy]
The first query gets the whole model list…
The second query will be performed after a model is clicked. Something like: select * from modelinfo where modelID=modelIDinFlash.
The third query is what I have a lot of trouble with! This has to run on the same time or immediatly after the second query. It reads the picture urls and id’s from that particular model. I need the filenames for the picture viewer.
But everytime I try this third query, the site becomes very slow and have problems displaying the model info.
[/COLOR]
NOW I have a temporary solution: in the first table I have a field which states how much pics each model has, and this number Flash uses to build the nr buttons. But this is not a very solution since I want to keep everything dynamic. I also want to build a drag and drop function… something like a shopping cart. For that to work, every picture must have an unique ID!
I hope someone has some tips for me on this matter! How to deal with 3 XML queries…
This is the link if you need to know what I’m talking about:
http://www.eyecatchers-models.com/v1/
Thanks in advance!
