# MySQL - Flash interaction

**URL:** <https://forum.kirupa.com/t/mysql-flash-interaction/26749>\
**Category:** flash\
**Created:** [July 25, 2003, 11:13pm UTC](https://forum.kirupa.com/t/mysql-flash-interaction/26749 "2003-07-25T23:13:12Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Baggio](https://avatars.discourse-cdn.com/v4/letter/b/dbc845/32.png) [@Baggio](https://forum.kirupa.com/u/Baggio)\
**Post date:** [July 25, 2003, 11:13pm UTC](https://forum.kirupa.com/t/mysql-flash-interaction/26749/1 "2003-07-25T23:13:12Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [July 26, 2003, 12:22am UTC](https://forum.kirupa.com/t/mysql-flash-interaction/26749/2 "2003-07-26T00:22:25Z")

</div>

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](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](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() =)

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [July 26, 2003, 12:26am UTC](https://forum.kirupa.com/t/mysql-flash-interaction/26749/3 "2003-07-26T00:26:25Z")

</div>

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