MySQL - Flash interaction

programming flash
1

Is there anyway of getting the two to interact?

Basically I’m creating an SWF which is sort of a slide show type thing, the only thing is that it will hold hundreds of photos which will be loaded externally and each image will have with it a small description… and to store all this info in a flat file would probably be slow.

If there is a way to do it with mysql/flash/perl that would also be good

Thanks for any tips

2

i don’t know any perl, I use php for server-side interactions.

You can store the data in a database like this:<table border=“1” cellpadding=“0” cellspacing=“0” style=“border-collapse: collapse” bordercolor="#111111" width=“88%” id=“AutoNumber1” height=“23”>
<tr>
<td width=“17%” align=“center” height=“23”><font face=“Verdana” size=“1”>id</font></td>
<td width=“61%” align=“center” height=“23”><font size=“1” face=“Verdana”>
URL_to_image</font></td>
<td width=“72%” align=“center” height=“23”><font size=“1” face=“Verdana”>
description</font></td>
</tr>
<tr>
<td width=“17%” align=“center” height=“23”><font face=“Verdana” size=“1”>1</font></td>
<td width=“61%” align=“center” height=“23”><font face=“Verdana” size=“1”>
http://www.domain.com/image1.jpg</font></td>
<td width=“72%” align=“center” height=“23”><font face=“Verdana” size=“1”>
this is my first image</font></td>
</tr>
<tr>
<td width=“17%” align=“center” height=“23”><font face=“Verdana” size=“1”>2</font></td>
<td width=“61%” align=“center” height=“23”><font face=“Verdana” size=“1”>
http://www.domain.com/image1.jpg</font></td>
<td width=“72%” align=“center” height=“23”><font face=“Verdana” size=“1”>
image 2</font></td>
</tr>
</table>
and then do the querying based on that. After you get the string with the images’ urls, you use it to load the jpeg using loadMovie() =)

3

Hmm thanks but that wouldn’t work in my case because all i want to do is have a single swf file which loads only once. Then user then presses forward/back buttons on the swf to browse through the images. But the information about the images, their description, url etc will be kept in a DB…

Hope that makes sense