How to use Blending Image Slide Show Script with PHP/MySQL for img src

[branding4you]

Im having some problems getting this to work:

<?php 
error_reporting (0); 

// Connects to your Database  
mysql_connect("localhost", "root", "") or die(mysql_error()) ;  
mysql_select_db("travelinit") or die(mysql_error()) ;   

//Select Query for images from db
$query="SELECT id, fld_imagename FROM tbl_banner";
$result = mysql_query($query) or die(mysql_error());   

//Loop to get image names from query
while($row = mysql_fetch_array( $result )) 
{ 
//Write image path and names on page - NAMES ARE PULLED FROM DB
echo "".$row['fld_imagename']. ","; ?> </br>

<?php } ?>

then some html code here ... followed by the script where my problem is:

<script language="JavaScript1.1">
<!--

//*****************************************
// Blending Image Slide Show Script- 
// © Dynamic Drive (www.dynamicdrive.com)
// For full source code, visit http://www.dynamicdrive.com/
//*****************************************

//specify interval between slide (in mili seconds)
var slidespeed=3000

//specify images
var slideimages=new Array(<?php NEED TO HAVE THE MYSQL ARRAY DATA HERE ?>); 

var imageholder=new Array()
var ie=document.all
for (i=0;i<slideimages.length;i++){
imageholder[i]=new Image()
imageholder[i].src=slideimages[i]
}

function gotoshow(){
if (newwindow)
window.open(slidelinks[whichlink])
else
window.location=slidelinks[whichlink]
}

//-->
</script>

need the above line of code code to pull from MYSQL where it says "NEED TO HAVE THE MYSQL ARRAY DATA HERE"

the original line of code looks like this:

var slideimages=new Array("topbanner/1.jpg","topbanner/2.jpg","topbanner/3.jpg") 

Seen this line of code by: jscheuer1 of DD

fadeimages[0]=[".<?php echo $row_Recordset1['photo1']; ?> ", "", ""]

have tried doing this but nothing works..

slideimages[0]=[".<?php echo $row['fld_imagename']; ?> ", "", ""]

please help im no good at javascript yet and want to learn

thank you
Mike

[fastsol1]

try this

//Loop to get image names from query
while($row = mysql_fetch_array( $result )) 
{ 
//Write image path and names on page - NAMES ARE PULLED FROM DB
$img[] = $row['fld_imagename'];
} 

<script language="JavaScript1.1">
<!--

//*****************************************
// Blending Image Slide Show Script- 
// © Dynamic Drive (www.dynamicdrive.com)
// For full source code, visit http://www.dynamicdrive.com/
//*****************************************

//specify interval between slide (in mili seconds)
var slidespeed=3000

//specify images
var slideimages=new Array(
<? 
foreach($img as $i)
{
  echo "\"$i\" ";
} 
?>); 

var imageholder=new Array()
var ie=document.all
for (i=0;i<slideimages.length;i++){
imageholder[i]=new Image()
imageholder[i].src=slideimages[i]
}

function gotoshow(){
if (newwindow)
window.open(slidelinks[whichlink])
else
window.location=slidelinks[whichlink]
}

//-->
</script>