'0') { ?> '0') { $mybanners = implode("', '", $a2); $mystr = "'$mybanners'"; //get the clicks $q3 = "select count(*) from yellow_stats where BannerID in ($mystr) "; $r3 = mysql_query($q3) or die(mysql_error()); $a3 = mysql_fetch_array($r3); $clicks = $a3[0]; } else { $clicks = '0'; } echo "\n\t\n\t\n\t\n\n\n"; } echo "
Name Banners Clicks
$a1[FirstName] $a1[LastName]$banners$clicks
\n\n
"; } ?>