mssql_fetch_row();
| From: | Infomart) | Date: | Fri, 11 Apr 2003 14:16:16 +0000 |
| Subject: | mssql_fetch_row(); | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-143501@lists.php.net to get a copy of this message | ||
Hi,
In my script, I take our the first 20 entries of my SQL table like this:
$query = "SELECT * FROM updateHistory WHERE AIX = '$search' ORDER BY VAX";
$result = mssql_query($query);
for ($i = $start; $i < mssql_num_rows($result); ++$i)
{
$updateHistory = mssql_fetch_row($result);
// code here....
$numRecord+=1;
if ($numRecord==20) {
break;
}
}
THis code successfully processing the first 20 entries of the data I took
out from the query. My question is, how do I take out the 21st to the 40th
entries?...or 41st to 60th entries?..basically I want it to function so that
it can process the 'next 20' each time.
Please advise, thanks
Kelvin