mysql_num_rows for each Field

[luiddog]

I have the following statement:

SELECT Username, UserDate > NOW() AS Past, UserDate < NOW() AS Future FROM User WHERE Username = 'Tom'

How can I display the total rows of Past and Future seperatly. All I can do with mysql_num_rows is display the total count not each indivdual count.

[Lars_Berg]

select username,
 sum(case when userDate > current_date then 1 else 0 end) as future,
 sum(case when userDate < current_date then 1 else 0 end) as past
 from user
 where username = 'Tom'
 group by username

[luiddog]

Works Great. Thanks.