populate an array from a querry

[Anon]

Hi all,

Here's my code:

$result = mysql_query ("SELECT Club, SumOfNum, Members FROM club_by_district WHERE Dist = $district
ORDER BY Club",$db);
While (List ($club, $sum, $mem) = mysql_fetch_array($result)){

$names = array($club);
$values = array($sum);
$dvalues = array($mem);
}

The problem is I only get the last value from each query.

Thanks,
Mark

[lxghak]

I think you want to change:

$names = array($club);
$values = array($sum);
$dvalues = array($mem);

To:

$names[] = $club;
$values[] = $sum;
$dvalues[] = $mem;

[Anon]

Thanks!! That did it.