Revenue Sharing Hack Correct?

[Boardhost]

Well instead of getting noe like NP i made one for a friend. Only problem is I don't think i can test it so i am going to ask here if it will work.

Basically i have a custom profile field they put their google ad in. then the google script looks like this:

<?php require_once('Connections/google.php'); ?>
<script type="text/javascript"><!--
google_ad_client = "pub-<?php
$query= "SELECT * FROM 'userfields' COL 'field5' ORDER BY RAND() LIMIT 1";
?>";
google_ad_width = 728;
google_ad_height = 90;
google_ad_format = "728x90_as";
google_ad_channel ="";
google_color_border = "03225A";
google_color_bg = "03225A";
google_color_link = "FFFF00";
google_color_url = "FFCC00";
google_color_text = "FFFFFF";
//--></script>
<script type="text/javascript"
  src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>

The db connection works fine. Just hinking, will this take a random row from the database? it works at the moment but only one google ad is in the fields

Danny

 

[adam_uk]

your setting the query variable but your not loading the data from the db by the looks of it.

 

[Boardhost]

ok thanks for that

Danny