Counting Occurrences within an If statement

I have been working on the something for the last day and can't figure it
out.



I am pulling 7500 rows from a MySQL database, but I only want to display a
certain numbers of rows based up an if statement. I want to count the rows
within the if statement.



mysql query result



if(x < y){

display a row in a table

}else{

Don't display anything

}



Every time a row is displayed, I want to add one to a counter



markb