[RESOLVED] How would I go about..

zTagged

Doing something like this:
Listing the number of rows where a specific column has a value?

Like if 3 rows had column error with a value of y in it, having it echo to a specific user that
"You have 3 errors waiting to be resolved" or something similar?

Example: A user notices there's an error in their information. Instead of having them edit it themselves, we need a manager to edit it. What they'd do is mark the error column to a value of 'y'.

Manager logs in, and has a message on their welcome screen: "1 user has marked their record as errored."

:queasy:

laserlight

Listing the number of rows where a specific column has a value?

Do a SELECT COUNT(*) ... WHERE column=value

zTagged

laserlight wrote:
Do a SELECT COUNT(*) ... WHERE column=value

So SELECT COUNT (*) FROM table WHERE error='y' then do the query. Check.

How would I echo out the number of rows, though?

laserlight

The SELECT COUNT() is guaranteed to return exactly one row in the result set. Since you only specify COUNT(), this row has exactly one column. So just retrieve that field.

zTagged

laserlight wrote:
The SELECT COUNT() is guaranteed to return exactly one row in the result set. Since you only specify COUNT(), this row has exactly one column. So just retrieve that field.

Ahh, gotchya. Thanks!