Need help with a array

[dwilson]

Here is the code I'm using so far:

$sql = "SELECT polk_data.make,
            polk_data.state,
            polk_data.body,
            COUNT(polk_data.make) as makecnt
        FROM polk_data
        WHERE polk_data.body = 'Livestock'
        AND polk_data.state LIKE 'W%'
        GROUP BY(polk_data.state),(polk_data.make)
        ORDER BY polk_data.state DESC";

$result = mysql_query($sql,$cn) or die($sql.mysql_error());

Now when I do a print_r the array looks as follows:
Array
(
[make] => BARRETT TRAILER
[state] => WY
[body] => Livestock
[makecnt] => 1
)
Array
(
[make] => MERRITT EQPT
[state] => WY
[body] => Livestock
[makecnt] => 1
)
Array
(
[make] => WILSON TRAILER
[state] => WY
[body] => Livestock
[makecnt] => 6
)
Array
(
[make] => M H EBY
[state] => WV
[body] => Livestock
[makecnt] => 1
)
Array
(
[make] => MERRITT EQPT
[state] => WV
[body] => Livestock
[makecnt] => 2
)
Array
(
[make] => M H EBY
[state] => WI
[body] => Livestock
[makecnt] => 2
)
Array
(
[make] => WILSON TRAILER
[state] => WI
[body] => Livestock
[makecnt] => 3
)

My question is there any way to group the state together or store it into a temp table so that it could look like
Wy
BARRETT TRAILER => 1
MERRITT EQPT => 1
WILSON TRAILER => 6

WV
M H EBY => 1
MERRITT EQPT => 2

WI
M H EBY => 2
WILSON TRAILER => 3

[sarahk]

Is the data storage that concerns you or how to 0utput it to the browser?

If it's output then this code snippet should help

$result = mysql_query($sql,$cn) or die($sql.mysql_error());
$curState = 'X';
while ($row = mysql_fetcharray($result)) //have I got the syntax right? check
{
  if ($row['state'] != $curState) 
  {
    echo "<p><b>{$row['state']}</b></p>";
    $curState = $row['state'];
  }
  echo "<p>{$row['make']} => {$row['makecnt']}</p>"; 
}

[dwilson]

Thanks, it close to what I want but you have pointed me in the right direction. Thanks again