array total

[kimi]

Hi..

My code

for ($x=0; $x < $totalsport; $x++) {
  $query = "SELECT * FROM sudent
                    WHERE sports_house = '$arrq[$x]' ";
  $result = pg_exec($query);                   

  $total = pg_numrows($result);
}   

This will give a total for each sports_house.
How to array this totals??
Please help.
Thanks in advance.

[Jayson]

Instead of $total = pg_numrows($result);, try

$total[$x] = pg_numrows($result);

Then you'll have an array $total with an element for each set. Does that answer your question?

[Weedpacket]

What would be a lot faster would be

$query = "SELECT sports_house, COUNT(*) AS count from sudent GROUP BY sports_house";
$result = pg_exec($query);

Fetching arrays from that resultset would give arrays ('sports_house'=>sports_house name, 'count'=>total)

[kimi]

Okey i got it..

Thanks to both of you 🙂