loading mysql data into a javascript array

[Jem]

Hi all

I'm having a bit of trouble loading data from my mysql database into a multidimensional javascript array. The array looks like this:

var pics = new Array (
new Array(1,"pics/one.gif"),
new Array(2,"pics/two.gif"),
new Array(3,"pics/three.gif"),
new Array(4,"pics/four.gif"),
new Array(5,"pics/five.gif")
);

and works fine with the static data.

The table is called content_attachments and the columns are ID and Image so should look like: new Array($ID,"$Image"),

Any help would be appreciated

[The_Chancer]

$query=mysql_query("SELECT ID,Image FROM `table`");
$jscriptarray="var pics = new Array (";
while($foo=mysql_fetch_assoc($query))
{
    $jscriptarray.="new Array(".$foo['ID'].",\"".$foo['image']."\"),";
}
$jscriptarray=substr($jscriptarray,0,-1);
$jscriptarray.=");";
echo $jscriptarray;

Should give you what you need....

[Jem]

Thanks! That did the trick 🙂