I've got the query...can't figure out the PHP

I have a table with customer info. I have the following query that returns the number of customers in each state:

SELECT state, count( * )
FROM 2004bih
GROUP BY state
ORDER BY count( * ) DESC LIMIT 0 , 30

Not sure what PHP code I need to use to output into a table like:

VT 90
MA 85
CT 43
NY 34
AZ 22
AK 2

Any help would be appreciated!

Thanks,

Christian

SELECT state, count( customer ) as num_cust
FROM 2004bih
GROUP BY state
ORDER BY num_cust DESC LIMIT 0 , 30

<table>
<?PHP
while ($get = mysql_fetch_array($result)){

echo "<tr><td>". $get["state"] . "</td><td>".$get["num_cust"]."</td>";

}
?>
</table>

Used the example, and it seems to be outputing the last state in the array.

Output:

CT 1

And that's it. I know there are more than 1 state in the db... 🙂

Christian

I figured it out. My mistake. It's working great. Thanks for the help. Much appreciated.

Christian