kurtos123 Posted August 14, 2015 Share Posted August 14, 2015 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> ?> Quote Link to comment Share on other sites More sharing options...
blmg2009 Posted August 14, 2015 Share Posted August 14, 2015 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. Quote Link to comment Share on other sites More sharing options...
ginerjm Posted August 14, 2015 Share Posted August 14, 2015 Or you could post on the forum that caters to paid services, not here. 1 Quote Link to comment Share on other sites More sharing options...
kurtos123 Posted August 14, 2015 Author Share Posted August 14, 2015 ok thanks for your help and tips ! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.