[scottyadam]

I have 2 queries that will now query a database, one that will count all the results (so I can get the paging and limits:

SELECT COUNT(id) as num FROM testinfo_tbl

and then another one that will do the limit to only return the results that I actually want:

SELECT id,name,blah1,blah2,blah3 FROM testinfo_tbl

Is there a way to do this in 1 mysql query, as I am trying to reduce the amount of queries I send to the database...slowing things down...

[scottyadam]

figured it out...just needed a little more research

http://dev.mysql.com...tion_found-rows

[BerndB]

Hello,

the "Select ...." Query give you only a Resultset, NOT THE RESULTS.

So after you query the Database you can get with get_num_rows($res)

the number of Rows from the Resultset.

Here ist a Sample in PHP. It works also in each other Language

http://php.net/manua...ql-num-rows.php

<?php

$link = mysql_connect("localhost", "mysql_user", "mysql_password");
mysql_select_db("database", $link);

$result = mysql_query("SELECT * FROM table1", $link);
$num_rows = mysql_num_rows($result);

echo "$num_rows Zeilen\n";

?>

Bernd

This post has been edited by Atli: 31 December 2012 - 09:16 AM
Reason for edit:: Please use [code] tags when posting code.

[Atli]

BerndB, please note that the code you posted is a horrible example. You fetch ALL the data from the table, only to count the number of rows it returns. It's extremely wasteful. In such a situation, using the COUNT() function in an SQL query, like scottyadam does in his first post, is a FAR better solution.