Hi I am using windows2000 server and MYSQL ver3.23.41-win and Active Server Pages to retreive MYSQL result set to my webpage, It is retreiving well if there is only one row in the table( It is not reaching EOF immediately), but if there is more then one row (in group by result) then immediately reaching EOF. How can i move to the BOF. Please guide me in this issue. My query is : Select agent_code,count(agent_code) AS Expr1 from eworkeronline_workers where (sno<>0) and (selected=0) and (subskillID='101')and ( age = 18 or age=19 )group by agent_code Thanks selva --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php