Execute("SELECT id,imageurl,bannercode,published FROM #__banners WHERE $show published = 1 "); if( $rs && $rnum=$rs->RecordCount()>0 && $rsa=$rs->GetArray() ) { if($show==""){$rand=rand(0,$rnum); $row = $rsa[$rand];}else { $row = $rsa[0]; } if($row['bannercode']!='') { echo $row['bannercode']; }else { echo ""; } change_val("banners",$row['id'],"imphits",1); } } } $bannerid = @$params->get('bannerid' ,false) ; showbanner($bannerid); ?>