Help with an Array
Posted on 2005-05-02
I need help with getting two values from my MySQL database and storing them in an array. After that, I need to display them on my webpage. I have my SQl done as far as getting the values, it is putting them into an array that I need help with. Basically what I am doing is getting the number of open jobs that have been posted on our website sorted by the state abbreviation. This is my DB query:
SELECT count(*) AS Projects, hosp_state AS State FROM projects GROUP BY hosp_state;
That is about as far as I have gotten. Any help would be greatly appreciated.