i am trying to do :

[pelegk2]

SELECT *,COUNT(*)  FROM myDB WHERE user_name LIKE '%%' AND done_date>='1041372000' AND done_date<='1072908000' AND locate('

what i actually want is all the select answer+ how many total rows effetcted in 1 query withought using

mysql_affected_rows() 

is it possible?how?
thanks in advance
peleg

[cosminb]

from the manual :

mysql_affected_rows() does not work with SELECT statements; only on statements which modify records. To retrieve the number of rows returned by a SELECT, use mysql_num_rows().