Ovako sam ja to uradila
Code:
<?php
echo 'var filename =new Array();'; //Define array in JavaScript
echo 'var link =new Array();' ;
$conn=mysql_connect("XXXXXXX","XXXXXX","XXXXX");
mysql_select_db("aad_dbase");
$query = "SELECT * FROM Banners ORDER BY id DESC";
$result = mysql_query($query);
$i = 0;
while($row = mysql_fetch_assoc($result))
{
extract($row);
$id = $row['id'];
$link = $row['link'];
$file = $row['filename'];
$status = $row['status'];
// $image_array = array();
// $image_array[$i] = $file;
// $link_array = array();
// $image_array[$i] = $link;
echo "filename[$i] ='$file'<br />";
echo "link[$i] ='$link' <br />";
$i++;
}
?>
///Pa javascript
<html>
<HEAD>
<meta http-equiv="Content-Language" content="en-us">
<script src="array.php"></script>
<script type="text/javascript">
var curimg=0
function rotateimages(){
document.getElementById("slideshow").setAttribute("src", "updates/static"+filename[curimg])
curimg=(curimg<galleryarray.length-1)? curimg+1 : 0
}
window.onload=function(){
setInterval("rotateimages()", 2500)
}
</script>
</HEAD>
<BODY>
<div style="width: 170px; height: 160px">
<img id="slideshow" src="uploads/static/mixed_mates.jpg" />
</body>
</html>
<?php
echo 'var filename =new Array();'; //Define array in JavaScript
echo 'var link =new Array();' ;
$conn=mysql_connect("XXXXXXX","XXXXXX","XXXXX");
mysql_select_db("aad_dbase");
$query = "SELECT * FROM Banners ORDER BY id DESC";
$result = mysql_query($query);
$i = 0;
while($row = mysql_fetch_assoc($result))
{
extract($row);
$id = $row['id'];
$link = $row['link'];
$file = $row['filename'];
$status = $row['status'];
// $image_array = array();
// $image_array[$i] = $file;
// $link_array = array();
// $image_array[$i] = $link;
echo "filename[$i] ='$file'<br />";
echo "link[$i] ='$link' <br />";
$i++;
}
?>
///Pa javascript
<html>
<HEAD>
<meta http-equiv="Content-Language" content="en-us">
<script src="array.php"></script>
<script type="text/javascript">
var curimg=0
function rotateimages(){
document.getElementById("slideshow").setAttribute("src", "updates/static"+filename[curimg])
curimg=(curimg<galleryarray.length-1)? curimg+1 : 0
}
window.onload=function(){
setInterval("rotateimages()", 2500)
}
</script>
</HEAD>
<BODY>
<div style="width: 170px; height: 160px">
<img id="slideshow" src="uploads/static/mixed_mates.jpg" />
</body>
</html>
Hvala