Pulling data from MySql with PHP

[Anon]

I have a helpdesk database that I set up and now that it is working fine I want to be able to pull data from the database and display it in a numerical format on my main page. What I am trying to do is, for example.

I want to show how many open help tickets there are so I need to check the resovled column for the string 'No' and then add them all together to get a number that I can post. I would like to do this for many of my data fields but if I could get help on just doing one I can figure out the rest.

Thanks
Rick

[Anon]

Are you asking to write for the SQL Queries ?? The simple query will do. For writing the sql statement please refer to any of Mysql book..

[Anon]

Never mind all I figured it out. I know how to do the queries but I am very new to SQL and very very new to PHP so it took a short while to figure it out. But, I got it anyhow.

Thanks
Rick