I have the results of a MySQL query obtained using PHP as follows
$result = $handle->query( $query );
I can navigate from first to last record with a loop using
$item = $result->fetch_assoc();
I need to know how to navigate freely among the records in the resultset.
I have done recordset navigation in MS Access with VB and with Java. Does PHP/MySQL support
moving the internal record pointer?
Are there PHP functions for operating on $result other than fetch_assoc()?
I use mysqli( ... ) to make the database connection.