cursors

[quinten]

I want to use a cursor to go through a large table (the result of a query from an SQLServer database). I know about how to declare it and all (declare, open, fetch, close), but only when I use just SQL code. How can I create and use such a cursor in my PHP code?

For normal queries where I want a complete resultset I use something like this inside PHP tags:
$my_query = "SELECT x FROM y";
$result = mssql_query($my_query) or die("error");

I just don't see how I can do something analog, but with a cursor I can use to scroll through the query result.

[barand]

$my_query = "SELECT x FROM y"; 
$result = mssql_query($my_query) or die("error"); 

You have now created the cursor in $result. To scroll through it

while ($row = mssql_fetch_array($result) ) {

 echo $row['x'] . "<br>";
}

Check out [man]mssql_fetch_array[/man]
Check out [man]mssql_fetch_row[/man]

hth

[Sxooter]

Here's how I do it in Postgresql:

<?php
$i=0;
$res = pg_query($conn,"declare cursor...");
while ($i==0){
    $res1 = pg_query($conn,"fetch x from cursorname");
    if (some test condition means we're done here) $i=1;
}