hi everybody, i have a simple problem, but somehow i couldn't solve it i hope someone overthere can help me. i have a select query as below: select no,subject,ndate from cat1 where news like '%"+search+"%' limit "+page_no+",5" i also want to find out how many rows are there in the result set. what is the easiest way to do this? actually , i wonder if there is a facility such as: select count(*) from (select no,sub.........) but this doesn't work. is there a similar way? the only way i could think of is creating a table with the first select query and then counting it eg: query1=create table temp as select 'query1' select count(*) from the_table_resulted_from_query1 but this seems too inefficient and stupid way. any one has a better idea? thanks a lot?
--------------------------------------------------------------------- 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