Moving through a MySQL DB 1

[TheConeHead]

Where with asp and SQL I can say rs.MoveNext(); to move from one record to the next, how would I do that with MySQL and PHP?

 

[sleipnir214]

There is no exactly equivalent to MoveNext and (I assume the existence of) MovePrev. PHP's builtin functions are not object-oriented.

There are two ways to move through a MySQL return recordset.

First is to traverse them in order. The mysql_fetch_[row|assoc|array|object]() functions fetch a row and move the recordset pointer to the next record. A simple while() loop is all that is needed, as demonstrated in the example code here:

http://us4.php.net/manual/en/function.mysql-fetch-assoc.php

Second is random-order traversal. You do this by using mysql_data_seek(). There is example code on the PHP online manual page for mysql_data_seek():

http://us4.php.net/manual/en/function.mysql-data-seek.php

Generally, I recommend using the in-order traversal and ordering the recordset through the use of SQL "WHILE" clauses.


Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!