My random problem!

[trafix]

Hmmm thanks mr e,

I actually didnt think of that....doh...but it didnt work either I even tried

PHP Code:

//############### start advertising / sponsorship banner #############
$showad = $DB_site->query_first("SELECT * FROM ads WHERE forumidnum='$forumid'");
    if (empty($showad[forumidnum]) or $showad[forumidnum] =="") {
  $randomad=$DB_site->query("SELECT * FROM ads ORDER BY RAND() desc LIMIT 1");
   eval("\$showthisad .= \"".gettemplate("ads_bannerbank")."\";");
 } else {    
eval("\$showthisad .= \"".gettemplate("ads_forum_sponsor")."\";");
} 


and it didnt work either

I only have 3 banners on the table so far and they do work when a target forum is nominated eg here i have also managed to make the ad banner to appear at the top of all threads in the nominated forum as well. i have even got it to display the sponsorship in the forum list. there are 2 sponsored forums here
http://www.atmyparty.com/network/for...s=&forumid=172

I have attached a gif of the current data table, so i spose to answer your question....if you are viewing forum number 28 the cell more correctly is not there rather than empty. so by defult i want to display a random banner in the unsponsored forum/threads.

Thanks so far for your ideas...