a limit by query but getting total number at once?

[padders]

I am doing a limit by select query but want to also know the actual number of results there would be if it wastn't limited. So bascially, i want say the 20 links between 20 and 40 but also want to know there are 93 links that satisfy the condition. Can i do this or do i need to do a seperate count query as well?

[Anarchos]

You could either have a separate query or grab all of the results and then only use results 20-40 in your script.

[petesmc]

Hi,

You could do two things.....first is get the the number of rows:

$select1 = mysql_query("SELECT * FROM table LIMIT 20");
$select2 = mysql_query("SELECT COUNT(*) as number FROM table");
$number = $select2["number"];

Or you could limit in your script:

$select1 = mysql_query("SELECT * FROM table");
while ($result = mysql_fetch_array($select1)) {
$arr[] = array(
"DateAdded" => $result["DateAdded"],
"Name" => $result["Name"])
}
}
$number = count($arr);

// LATER print variables like:

reset($arr);
foreach($arr as $key => $val) {
$i = 1;
$date = $arr[$key]["dateAdded"];
$name = $newsdata[$key]["Name"];

if ($i < 20) {
print $Name;
print "<br>$date";

$i++;
}
}

?>


Hope this helps,
Peter

[padders]

it did, i went for the count option, i think it will be more efficient here, also read that the count query will be cached by the database so will not use up much resources to get it.

thanks