Sams Teach Yourself MySQL in 21 Days, Second Edition

Handling Resultsets

Although the program in Listing 13.4 retrieves and tests a resultset from a query, it doesn't do anything with it. We need some functions for processing the data in a resultset.

You saw that you can use mysql_store_result() or mysql_use_result() to fetch the result of your query. Whichever you use, you can access one row of that data at a time using the function mysql_fetch_row().

The syntax for mysql_fetch_row() is as follows:

mysql_fetch_row (*result)

It returns the next row of data in the datatype MYSQL_ROW. Each time the function is called, it returns the next row, until there are no more rows, whereupon it returns NULL.

If you use mysql_store_result(), you have the advantage of some extra functions that let you move ...