Thanks, that's what the result I wanted.
The table takes values from submit form and I want to process the user's request after viewing a report.
But how do I use that 42 rows. Here's my table stricture:
id text_field status user_id request
I should really change the request to action.
The main point is how many HIGH, LOW, MIDDLE statuses the user requested which needs to take an action? I set 1 = 'not done yet', 2 = 'rejected', 3 = 'done'. The query request all fields but I only want to count status column so I cloud review the user's request history.
Hope I make it clear.
UPDATE: It doesn't work in the while loop.