sql commnad in a for loop !

I wanna make the following sql query which looks a bit complicated., and put it in a for loop too for all days from 1 to 31. ================================================== for $day=1 until $day=31 { count how many records (rows) there are in the tracker table, without counting rows that contain the same "user_id" value, when the day=$day. } ================================================== how do i CALL then each result to display them in a web page ? Can something like that happen, or shall I repeate the same query 31 times ? :( Thanks in advance.. -- ~~~~~~~~~~~~~~~~ Sapilas@/dev/pinkeye ~~~~~~~~~~~~~~~~