$query = "SELECT activities FROM tasks " ;
$results = odbc_do($connectstring, $query);
odbc_fetch_row($results, 5);
In the above example lets asume that the table tasks has 50,000 rows in it.
Obviously, when I issue the command odbc_fetch_row($results, 5); It will
return the 5th row. However, my question is the following.
Does the code actually selects the 50,000 rows from the table first or does
it just goes to the 5th row within the table ?
The reason I ask is because I am trying to write code to display x number of
rows at a time and then use a next andprevious link. But if it loads the 50k
rows everytim that is not good.
Thanks,
JT
