Louisiana Members

[insert_php]
$currentClub=null;
$memberCount=0;
include_once (‘setvariables.php’);

$query=”SELECT racerNumber,clubNumber,racerFirst,racerLast,activeMember from rcdrlc5_dragtrac.racers where activeMember=’Y’ and clubNumber=’3′ order by clubNumber asc, racerlast asc”; $displayLabel=’Current Members’;
$result=@mysql_query ($query);
$num=mysql_num_rows($result);
if ($num >0)
{
while ($row=mysql_fetch_array($result,MYSQL_NUM))
{ if ($row[1]!=$currentClub)
{ $clubNameA=mysql_fetch_array(@mysql_query(“SELECT clubName from thekra7_dragtrac.club where clubNumber=’$row[1]’ limit 1″));
$clubArray[$row[1]]=$clubNameA[0]; $memberCount=0;
}
$club=$row[1];$racer=$row[0];
if (($row[4]==’N’) && ($UAC>=9)) { $cellBack=’ badBackground ‘;} else { $cellBack=null; $memberCount++;}
$requestFiller1=rand(6,10000);$requestFiller2=rand(5,1000);
$link=”$row[3], $row[2] • $row[0]
“;
$results[$club][$racer]=”$link”;
$currentClub=$row[1];
$memberCountA[$club]=$memberCount;
}
}
// else { echo $query; }

foreach ($clubArray as $key => $value)
{ $numberInClub=count($results[$key]);
echo “\n$numberInClub members\n
“;

foreach ($results[$key] as $key2=> $value2)
{ echo “$value2”;
$colCount++;
if ($colCount==$numberInColumn)
{ echo ‘‘; $colCount=0; }
}
}
[/insert_php]

Web Statistics