Is this possible in one Query ?

[TitanKing]

Hello, everyone, thank you for looking at my thread...

I am paging many results and need to split the pages mosty of the times. However is there any other way then doing a double query to count the number of total rows with LIMIT in the query? This wastes allot of resouces ?

I would be greatfull for any help or direction, thank you? :rolleyes:

[Plasma]

Yes, look into the SQL_CALC_FOUND_ROWS extension of MySQL.

Say you have:

SELECT * FROM table LIMIT 10

$num = mysql_numrows($result);
num holds 10.

(And theres 20 items in the table)

SELECT SQL_CALC_FOUND_ROWS * FROM table LIMIT 10
$num = mysql_numrows($result);
$total_result = mysql_query("SELECT FOUND_ROWS()");
$total = mysql_result($total_result, 0, 'FOUND_ROWS()');

num holds 10, total holds 20.

[TitanKing]

Thank you very very much ! This is an absolute breakthru, and few know about this 🙂

Thank you !