I want to display a random image on a web page every 30 seconds.   The
problem I am having is that I get multiple images on the same web page
all at once.  It's not clearing the previous image and then displaying
the new image.  Must have something to do with the loop its in:

<!-- Warning poor codinig listed below: -->
<TABLE>
<?
     mysql_connect("blah.com", "blah", "password");
     $query = "SELECT * FROM graphicstable ORDER by ID";
     $result = mysql_db_query("graphics", $query);

     $query = "SELECT COUNT(*) FROM graphicstable";
     $numguests = mysql_query($query) or die("Select Failed!");
     $numguest = mysql_fetch_array($numguests);
// echo "Result is: $result";


// Begin Randomizer Function
function random($max = 1) {
  static $startseed = 0;
  if (!$startseed) {
    $startseed = hexdec(uniqid(''))%getrandmax();
    srand($startseed);
  }
  return ((rand()/getrandmax())*$max);
} //end function

if ($result) {

$i = 0;
$number = 3;  //just to test number is total records in database

IF ($number == 0) :
    PRINT "<CENTER><P>There were no records matching
your                   query</CENTER>";
ELSEIF ($number > 0) :
    //PRINT "<CENTER><P>Search Results Returned:
$number</CENTER><BR><BR>";

WHILE ($i < $number):

// Assign variables within the loop
// sleep (10);
$bar =$numguest[0];
$foo = random($bar);   // call random function to get a new random pic

$record = mysql_result($result,$foo,"ID");
$cat = mysql_result($result,$foo,"category");
$name = mysql_result($result,$foo,"picture_name");
$rating = mysql_result($result,$foo,"rating");

// $name = mysql_result($result,$i,"name");
?>

<TR  bgcolor="#000000" ><TH><small>Name:<? echo "$name"; ?> Record: <?
echo "$record"; ?> Category: <? echo "$cat"; ?> Rating: <? echo
"$rating"; ?>Total Records: <? echo $numguest[0]; ?> </small></TH></TR>
<!-- 990000 is red -->
<!-- <TR><TD> <? // echo "<img src=/graphics/uploads/$name width=$width
height=$height><br>\n"; ?> </TD></TR> -->
<TR  bgcolor="#000000" ><TH>Random Number: <? echo "$foo"; ?> Record: <?
echo "$record"; ?> Height= <? echo "$height"; ?> Width= <? echo
"$width"; ?></TH></TR>
</TR>

<?

//PRINT "<BR><BR>";
$i++;
ENDWHILE;
//PRINT "</CENTER>";
ENDIF;

}
?>
</TABLE>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to