December 2002
Beginner
640 pages
16h 41m
English
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 ...