# How to populate this array from mysql

**URL:** <https://forum.kirupa.com/t/how-to-populate-this-array-from-mysql/234098>\
**Category:** Uncategorized\
**Created:** [July 30, 2007, 3:07pm UTC](https://forum.kirupa.com/t/how-to-populate-this-array-from-mysql/234098 "2007-07-30T15:07:05Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Baiji](https://avatars.discourse-cdn.com/v4/letter/b/a698b9/32.png) [@Baiji](https://forum.kirupa.com/u/Baiji)\
**Post date:** [July 30, 2007, 3:07pm UTC](https://forum.kirupa.com/t/how-to-populate-this-array-from-mysql/234098/1 "2007-07-30T15:07:05Z")

</div>

Hi, found this script on the site written by B. Rich. But how can I rewrite it to fetch the data from xml? I would also like to add an image.

I can do the mysql / php / xml bit but not the AS.

//Array with all our information  
memberInfo = [[“Kirupa”, “Flashing (MX) complete strangers in 32-bit color.”, “[http://www.kirupa.com/forum/member.php?u=1](http://www.kirupa.com/forum/member.php?u=1)”], [“B.Rich”, “Basketball, Golf, Web Media.”, “[http://www.kirupa.com/forum/member.php?u=4513](http://www.kirupa.com/forum/member.php?u=4513)”], [“Senocular”, “Fun stuff, like Flash”, “[http://www.kirupa.com/forum/member.php?u=2867](http://www.kirupa.com/forum/member.php?u=2867)”]];  
//Starting x & y values  
var xPos = 150;  
var yPos = 60;  
//For loop to attach our container movieclip and pass the array information  
for (i=0; i\<memberInfo.length; i++) {  
//attach the container clip  
attachMovie(“container”, “new”+i, i, {\_x:xPos, \_y:yPos});  
//increase the y postion each time  
yPos += this[“new”+i].\_height+5;  
//add the information  
this[“new”+i].name.text = memberInfo\*[0];  
this[“new”+i].interest.text = memberInfo\*[1];  
this[“new”+i].link = memberInfo\*[2];  
}

I appriciate all help!  
Tx, B