I've been rumaging around PM and also the forums at DevShed. On devshed I found mention of using SQL_CALC_FOUND_ROWS within a SELECT statement to have the database return the actual number of rows found for a query as if there was no LIMIT put in it. In order to get that you need to retrieve it with SELECT FOUND_ROWS() after the main query you've run. So how would I run that query after the first one to retrieve that answer if SQL_CALC_FOUND_ROWS was used rather than running a separate query to count the rows without a LIMIT? I won't list the code for a normal DBI query, its been done adnausium on PM and we all know we can find it on DBI
. Looking over the DBI docs it just seems that either I misunderstood the instructions but if I prepare another statement it destroys whatever I did before. So is there a way to retrieve the rows from SQL_CALC_FOUND_ROWS without any overly fancy code?