rotating 5 images in php

[kurtos123]

The result of below code can be seen on http://www.crocgame.com under Recommended Games (between purple on top)

My Question: Is it possible adjusting my code here and there, to show 5 new games after a certain time duration on the same index page so that images and corresponding urls (purple buttons) rotate on the webpage and it will be less boaring.

Anyone who helps me fix this can get 15 dollar on your paypal because i think you need to put some work in it.

Best regards,

Kurt

 

 

 

 

<?php
$iKolommen = 5;
?>
      <?php
              include_once("config.php");                           
              ?>
              <?php
              $rQuery = mysql_query("SELECT * FROM " . $pre . $sqlgame . " WHERE  (name LIKE '%candy crush%') OR (name LIKE '%goodgame farmer%') OR (name LIKE '%rummy%') OR (name LIKE '%goodgame empire%') OR (name LIKE '%Gorillaz Tiles%') OR (name LIKE '%goodgame shadow kings%') OR (name LIKE '%my free zoo%') OR (name LIKE '%my free farm%') OR (name LIKE '%kapi hospital%') OR (name LIKE '%garbage garage%')  OR (name LIKE '%11 legends%') OR (name LIKE '%dansen met de sterren%') OR (name LIKE '%skyrama%') OR (name LIKE '%seafight%') OR (name LIKE '%battlestar galactica%') OR (name LIKE '%pirate storm%') OR (name LIKE '%rising cities%') OR (name LIKE '%zoo mumba%') OR (name LIKE '%drakensang online%') OR (name LIKE '%uptasia%') ORDER BY RAND() LIMIT 5");
              $iCount = mysql_num_rows($rQuery);
              ?>
              <?php
              if(!$iCount)
              {
                ?>
                  <span style="color: white; text-align: center;">No games were found.</span>
                <?php
              }
              else
              {
                ?>
                <table width="780" cellpadding="0" cellspacing="0" align="center">
                  <tr>
                    <?php
                    $i = 1;
                    while($aGame = mysql_fetch_assoc($rQuery))
                    {
                      ?>
                      <td width="<?php echo (100 / $iKolommen); ?>%" align="center" style="text-align: center;">
                        <?php
                        if($aGame['cijfer'] != 0 AND $aGame['stemmen'] != 0)
                        {
                          $iCijfer = floor($aGame['cijfer'] / $aGame['stemmen']);
                        }
                        else
                        {
                          $iCijfer = 0;
                        }
                        $sSpelUrl = str_replace(" ", "-", $aGame['name']);
                        ?>
       <div style="float: left; margin-left:2px; width: <?php echo ($i == 2 OR $i == 3) ? "152" : "153"; ?>px; text-align: center;">
                        <a target="_blank" href="http://www.crocgame.com/games.php/<?php echo $sSpelUrl; ?>.html" class="recommendedLink">
                          <span class="iconwrapper"><img src="<?php echo $aGame['screenshoturl']; ?>" width="140" height="89" alt="recommend games" /></span>
                          <span class="recomendedButton" style="margin: 5px auto auto auto;">
                  <?php echo strlen($aGame['name']) > 19 ? substr($aGame['name'], 0, 19) . ".." : $aGame['name']; ?>
                  </span>
              </a>
          </div></td>     

?>

[blmg2009]

Please use the code tags [ code ] [ / code ] when pasting code on the forum it makes it easier to read. 

Like such: 

 

 

<?php
$iKolommen = 5;
?>
      <?php
              include_once("config.php");                           
              ?>
              <?php
              $rQuery = mysql_query("SELECT * FROM " . $pre . $sqlgame . " WHERE  (name LIKE '%candy crush%') OR (name LIKE '%goodgame farmer%') OR (name LIKE '%rummy%') OR (name LIKE '%goodgame empire%') OR (name LIKE '%Gorillaz Tiles%') OR (name LIKE '%goodgame shadow kings%') OR (name LIKE '%my free zoo%') OR (name LIKE '%my free farm%') OR (name LIKE '%kapi hospital%') OR (name LIKE '%garbage garage%')  OR (name LIKE '%11 legends%') OR (name LIKE '%dansen met de sterren%') OR (name LIKE '%skyrama%') OR (name LIKE '%seafight%') OR (name LIKE '%battlestar galactica%') OR (name LIKE '%pirate storm%') OR (name LIKE '%rising cities%') OR (name LIKE '%zoo mumba%') OR (name LIKE '%drakensang online%') OR (name LIKE '%uptasia%') ORDER BY RAND() LIMIT 5");
              $iCount = mysql_num_rows($rQuery);
              ?>
              <?php
              if(!$iCount)
              {
                ?>
                  <span style="color: white; text-align: center;">No games were found.</span>
                <?php
              }
              else
              {
                ?>
                <table width="780" cellpadding="0" cellspacing="0" align="center">
                  <tr>
                    <?php
                    $i = 1;
                    while($aGame = mysql_fetch_assoc($rQuery))
                    {
                      ?>
                      <td width="<?php echo (100 / $iKolommen); ?>%" align="center" style="text-align: center;">
                        <?php
                        if($aGame['cijfer'] != 0 AND $aGame['stemmen'] != 0)
                        {
                          $iCijfer = floor($aGame['cijfer'] / $aGame['stemmen']);
                        }
                        else
                        {
                          $iCijfer = 0;
                        }
                        $sSpelUrl = str_replace(" ", "-", $aGame['name']);
                        ?>
       <div style="float: left; margin-left:2px; width: <?php echo ($i == 2 OR $i == 3) ? "152" : "153"; ?>px; text-align: center;">
                        <a target="_blank" href="http://www.crocgame.com/games.php/<?php echo $sSpelUrl; ?>.html" class="recommendedLink"> 
                          <span class="iconwrapper"><img src="<?php echo $aGame['screenshoturl']; ?>" width="140" height="89" alt="recommend games" /></span>
                          <span class="recomendedButton" style="margin: 5px auto auto auto;">
                  <?php echo strlen($aGame['name']) > 19 ? substr($aGame['name'], 0, 19) . ".." : $aGame['name']; ?>
                  </span>
              </a>
          </div></td>     
?>

From what I gather from your description it sounds like you need javascript help not PHP. 

You can always google rotating images javacript or jquery and you should find some helpful info here. 

[ginerjm]

Or you could post on the forum that caters to paid services, not here.

[kurtos123]

ok thanks for your help and tips !