Flash/PHP/Mysql Dynamic Photo Gallery

Real Estate Slideshow Gallery. 1. Put a listing number into a text field in a .html or .php form 2. Retrieve listing info from mySQL DB, including pictureCount, Property Remarks, bedrooms, bathrooms...AND Transition and Display Effects. 3. Display the pictures for that listing in a photo gallery. -One Large picture placeholder on top (720px wide x 540px tall) with thumbnails in a scrollable menu below it. All this within div or textarea or table of a php page. I want to be able to add html above and around it so as to add other [login to view URL] must be in JPEG (.jpg) format and no larger than 3MB. Pictures come in different size and aspect ratios and should be resized on import in order to not go beyond the large picture placeholder. For example, most pictures are 4:3 but sometimes people turn the camera sideways and upload at a 3:4. In this case it will be too tall for the pictureHolder so the sides of the picture holder would need to croped. All the pictures should be adjusted so they are 540px tall (height of picture holder) even if that means they are not 720px wide, the aspect ratio must be [login to view URL] on a thumbnail will have it show in the big picture placeholder with transition effects and display effects. -hovering over a thumbnail will have it's border grow, change color or some kind of effect. -The large picture should change with a thumbnail click or automatically in 5 seconds. - When it changes there should be a transition effect, a slide, wipe, zoomout, zoomin, crossfade, or none. The effects will be predetermined with the effect type to use retrieved from the DB (see above). A whoosh sound will occur during the transition. - Once the transition is over, the display effect will commence. It will be pan, zoomin, zoomout, . Also determined by the database. Example of Effects: [login to view URL] Similiar: [login to view URL] and of the woosh sound in transitions: [login to view URL] Also, there will be a sound file that plays during the tour (mutable). Here is an example: [login to view URL]