I have a huge MySQL database that I keep track of worker assignments that have been assigned by supervisors. I have some PHP forms the supervisors assign things to workers via a browser. My question is, is there a way for me to use a SQL query to look at the MySQL database & count & display the number of assignments that is assigned to each worker? For instance, the database name is DATABASE1 & the table is named ASSIGNMENTS. In the ASSIGNMENTS table I have a field named WORKERS. The workers are identified in this field by worker1, worker2, worker3.....I would like to have a SQL that will look at the WORKERS field name & count how many times it sees worker1 & display it in a browser. I assume I would use PHP code to do this??? It would look like something below:
[b]Worker Name[/b] [b]Assigned Work[/b]
Thanks for any help provided.