Scroll Images Date wise

I want to scroll images. but those images stored in database.
I want to scroll images date wise.
Suppose I upload number of images today, then those images I only want to scoll on web site. Any body here who can help me?

along with the imges ,store the upload date. Whwn u retrive / scroll sort the images by the date field. Your problem will be solved.

thnx 4 ur help
bt i just want to know how can i reterive images from database?
i just want to store thm in a array.
can u help me how can i store database images in array..

I think Nobody is there who can help me!!!
Plz solve My problem!!!!!!!!!!

Hi svtpooja,

I don't know ASP.NET.....But i have done it PHP. My question is if you run a query then u always get a resultset. Using the resultset you can easily get the array. In java they are using iterator.

So take the image path from database and store it in array. Finally display the images one by one..I have done it php for ad banner images..Here is the sample code for your reference...

[CODE]

<img name="imgid" id="imgid" src="test.gif" width="180" height="90" border="0"/>
<?

db_connect() or die("database not connected");
$que = "select * from advert_master where category='S'";
$res = mysql_query($que);
$num = mysql_num_rows($res);
$i=0;
db_close();
while($num > $i)
{
$imgname = mysql_result($res, $i, "Image_path");
$Image = "../AdImages/".$imgname;
$Imgaeids.= "'$Image',";
$i++;
}
$Imgaeids = preg_replace("/,$/", "", $Imgaeids);
?>
<script language="JavaScript" type="text/javascript">
var imgids = [<?=$Imgaeids?>]
i1 = -1;
function swappartnerLogo() {
i1= Math.floor(Math.random()*imgids.length);
if (i1 > imgids.length - 1){
i1 = 0
}
if (imgids.length != 0){
document.images.imgid.src = imgids[i1];
}
setTimeout('swappartnerLogo()',2000);
}
swappartnerLogo();
</script>

[/CODE]

Thnx Suresh.....
:) :)