This is what I have:
SELECT ROUND((TO_DAYS(NOW())-TO_DAYS(birthdate))/365) as age, if(gender = 'M', COUNT(*), 0) as male, if (gender = 'F', COUNT(*), 0) as female
FROM users
GROUP BY age, gender

This is the result:
age, male, female
20 , 12 , 0
21 , 0 , 3
24 , 8 , 0
24 , 0 , 6
What I want is that the last two results are shown together, I mean like this:
24, 8, 6

DOes anyone know how to do this?

Question Answered on the Dreamweaver Ultradev Forum.

PS. Please try to avoid crossposting <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Joel Martinez

----------
set rs = conn.execute("SELECT answer FROM brain WHERE question = "& forumPost &"

Sorry about that.. <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>