$rrr2 = "SELECT * FROM dd_comments WHERE gameid='$ID' AND approved='1' ORDER BY date DESC LIMIT 3"; $sqltitle = "gamecomments0-".$ID ; if ($rrr1 = sqlcache($sqltitle, $cachelife, $rrr2)) { foreach ($rrr1 as $row ){
$ads1 = mysql_real_escape_string($_POST['ads1']);$ads2 = mysql_real_escape_string($_POST['ads2']);$ads3 = mysql_real_escape_string($_POST['ads3']);
<script type="text/javascript"><!--google_ad_client = "ca-pub-7662727282723239";/* Banner Right */google_ad_slot = "0650533672";google_ad_width = 120;google_ad_height = 600;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>
$ads1 = mysql_real_escape_string($_POST['ads1']);
After changing everything to Code: [Select]$ads1 = mysql_real_escape_string($_POST['ads1']); the ads have been fine so I guess that problem is resolved.
Currently my ads overlap the website content in some pages e.g. http://www.loosegame.com/index.php?action=play&ID=8004 in this page ads are covering the side links etc. Is there anyway I can adjust the page size so it doesn't clash with my ads positioning? Also I checked my website on another computer where it showed the advertisement is over the links in my home page. Do you know why is that? As on my laptop it shows the homepage is well structured and ads are not covering the side links.
Huh.. Can you show me a dump of just that row in the comments table?or could you show me the contents of your cache file for the game comments for Tank Trouble?Check inside your /cache/ directory and look for the "gamecomments0-{id}" file.
a:1:{i:0;a:12:{i:0;s:1:"2";s:2:"ID";s:1:"2";i:1;s:4:"8004";s:6:"gameid";s:4:"8004";i:2;s:2:"23";s:9:"commenter";s:2:"23";i:3;s:29:"Destroyed my brother at this ";s:7:"comment";s:29:"Destroyed my brother at this ";i:4;s:10:"1318777818";s:4:"date";s:10:"1318777818";i:5;s:1:"1";s:8:"approved";s:1:"1";}}
well that looks fine.. you sure you you have all the cache files set to 777?
How can I clear my cache?With the ads I am having trouble in my regular and testing site. I changed the code to this:Code: [Select]$ads1 = mysql_real_escape_string($_POST['ads1']);$ads2 = mysql_real_escape_string($_POST['ads2']);$ads3 = mysql_real_escape_string($_POST['ads3']);I tried this ad code in my testing site and the ads didn't show at all. And my ads in my main site have been up for the whole night and it hasn't disappeared.