loading mysql product records to new mc!

[scriptmonkey]

hi
i have a mySql db which holds a cataloge of products (id,image,description,cost,stock count, and price).

i would like to dynamicly load the information for each product in the table to a new movie clip that dynamicly loads to the stage.

i would like for all the products in the cataloge to load automaticly when the main movie loads and when new products are added to the database that these are also loaded to a new mc.

evenualy id like to be able to drag these mcs arround the stage so a client can organise the products into piles of things that they want and things that they dont.

is this possiable?

[tg]

yes, providing you know how to get information from a database to flash (you will need to know a serverside language like, asp, php,cfml etc.).
and you know how to create dynamic movieclips on the fly, and populate info in your mcs.
and you know how to make a movieclip respond to drag and drop....

all of it is possible, but there are lots of different steps to the process, pick one piece, to start with and build it up piece by piece.

[mayusefi]

yes, providing you know how to get information from a database to flash (you will need to know a serverside language like, asp, php,cfml etc.).
and you know how to create dynamic movieclips on the fly, and populate info in your mcs.
and you know how to make a movieclip respond to drag and drop....

all of it is possible, but there are lots of different steps to the process, pick one piece, to start with and build it up piece by piece.
Hi,
You have to use flash remoting for this season.
If you want to learn , contact me.
M.A.Yousefi

[tg]

yes you can use flash remoting, but you don't have to.

[scriptmonkey]

i have basic shopping cart setup ok with php - my sql all i need is some code that will dynamicly create a seperate mc for each item then look for the next item and do the same untill it finds no more items to load!

can anyone help me?