Php driven slideshow in flash

Hi everyone,

I need to create a slideshow in flash. About 15 category names need to be to the right of a slideshow. When the an image category is pressed, the images in that category load into the slideshow to the left. Previous and next buttons would let the user progress through the show. I’ve used

Hi everyone, I need to set up a slideshow in Flash MX 2004. There will need to be categories to the right of the slideshow so that when a category is clicked the relevant images for that category will load into the slideshow and be veiwable by pressing previous and next buttons. I need the slideshow to work with php and a MySQL database so that they can be updated regularly. I wondered if someone could outline for me how I’d create this slideshow using php, MySQL and actionscript. I know it’s a tall order but if someone could just point me in the right direction I’d really be grateful. I’ve currently set up a database in phpMyAdmin with 2 tables: the first table lists all the categories and also has a primary key; the second table contains 3 fields: one for the primary key, the second for the image number (which is used instead of a text description) and the third has the image file name (number.jpg). The image file name is equivalent to the numbers used when describing each image so I’m not sure if this is a double up and whether or not you can use the image number field to reference the image file name instead. Eventually, I’d need it to work like a shopping cart where there will be a button that says “Add to Order” and then when clicked, information about the current image in the slide show will be added to an order form - just a plain xhtml form. If someone could help out here in any way, it’d be much appreciated.