Adsense Code problems

CoryMathews · 07-12-2008, 01:27 AM

I have a wierd problem with my google adsense. I am trying to store the code in mysql and print it from a variable so that I can display different ads easily.

Problem is the google adsense does not show. It is in the source It creates a large area that it could fit into, but doesnt show the ad. If I hard code in the script it works just fine.

Im using mysql and I have tried storing the code in a varchar and in a text field.

Any Ideas?

drewbee · 07-12-2008, 07:06 PM

You sure the code is exact? I know the google code actually creates an iframe, but that does not seem like the likely reason. If you are putting the exact adsense code into the database, and simply retrieving it and outputing it, everything should work accordingly. Can you post your code?

CoryMathews · 07-12-2008, 07:30 PM

here is what the page outputs if you view the source.
Ijust added some spacing to see it better.

Code:

<div class="rightArea">
  <script type="text/javascript">
  <!--  google_ad_client = "pub-9855112947620642";  
    /* tuts234x60 */  
    google_ad_slot = "8462468271";  
    google_ad_width = 234;  
    google_ad_height = 60;  
  //-->  </script>  
  <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js">  </script>
</div>

And copied strait from the google site here is the ad.

Code:

<script type="text/javascript"><!--
google_ad_client = "pub-9855112947620642";
/* tuts234x60 */
google_ad_slot = "8462468271";
google_ad_width = 234;
google_ad_height = 60;
//-->
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>

And the php code that outputs it.
Query

PHP Code:


			
while($r=mysql_fetch_array($InfoResult)) {        

  $ExtraInfo=$r["ExtraInfo"]; 

  $Ad=$r["Ad"];

  $Ad2=$r["Ad2"]; 

}

Some other code then
Output

PHP Code:


			
echo "<div class=\"rightArea\">

  $Ad

</div>";

drewbee · 07-13-2008, 01:10 AM

*double post*

Everytime I go to edit something I end up putting it in the quick reply by accident grr.

drewbee · 07-13-2008, 01:11 AM

Ah, you are commenting out your google ad id with this line:

Code:

<!--  google_ad_client = "pub-9855112947620642";

Make sure there is a new line (return) after the <!-- part

Do you see the difference where the one copied straight from google, the <!-- is on a different line:

Code:

<script type="text/javascript"><!--
google_ad_client = "pub-9855112947620642";

I am guessing since google has no ID for you, they wont display anything.