Hello Dani Members I Have Question About My Code

<?php
$id = intval($_GET["id"]);
$result = mysql_query("SELECT * FROM peoples ORDER BY RAND() LIMIT 1");
while($row = mysql_fetch_array($result))
{
echo "$row[name]<br/>
<a href='members.php?id=$row[id]'><img class='img_shadow' src='$row[image]' width='198' height='250' alt='$row[name]' /></a>";
}
?>

This Code Get Me Image Of ONe Member And His Name Random

I need It To Show Another Member Every 5 Second Like Slide show

I tried Some jQuery Cycle Plugins But I Failed To get What I Need

Everytime I Click Refresh It Change The Query So I Need It To Show Automatically

I Hope I Explained My Question

I think what you need is automatic page refresh using javascript

Following javascript function will do the trick

<head>
    <script type="text/JavaScript">
        function refreshPage(timeoutPeriod) 
        {
            setTimeout("location.reload(true);",refreshPage);
        }
    </script>
</head>

Do the initial call in body onload

<body onload="JavaScript:refreshPage(5000);">

Thanks Sir Is This Refresh The Whole Page ?

I just Need The Image To Change

Just Like Slideshow

Just create an array containing all images, and set a javascript timeout function to change it.

Yes it is for whole page refresh. You can use AJAX to refresh only the image or also you can keep an array of images like @pritaeas suggested

Ok Thanks Sir iam Gonna Use Ajax To Solve This thanks Again

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.