Posted by Jerry Stuckle on 12/18/67 11:51

Garry wrote:
> How do I cycle through a MySQL query result one row at a time so that I can
> do some work on each individual row, instead of having the whole query
> scroll by. I need to have the ability to post each row to a form and then
> work on it, posting the results, then go on to the next row.
>
>
> Thank You in Advance for your putting me on the right track.
>
>
>

Garry,

You can't do it with a loop. You'll have to fetch a single row each time.

You could do it something like:

$last = 0;
$result = mysql_query("SELECT * FROM myTable WHERE id > $last ORDER BY id
LIMIT 1");
if ($result) { // Ensure it worked
if (mysql_num_rows() > 0) { // And returned data
$data = mysql_fetch_array($result);
// Process the row
$last = $data['id'];
}
else {
// End of data
}
}
else {
// Process the mysql error
}

Assuming id is a unique integer > 0 (or at least unique within other WHERE
clause settings).

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]