Skip to Main Content
Sams Teach Yourself MySQL in 21 Days, Second Edition
book

Sams Teach Yourself MySQL in 21 Days, Second Edition

by Tony Butcher
December 2002
Beginner content levelBeginner
640 pages
16h 41m
English
Sams
Content preview from 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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Sams Teach Yourself MySQL

Sams Teach Yourself MySQL

Chris Newman
Oracle® Database 10g Insider Solutions

Oracle® Database 10g Insider Solutions

Arun Kumar R., John Kanagaraj, Richard Stroupe
MySQL and mSQL

MySQL and mSQL

Tim King, George Reese, Randy Yarger
Jump Start MySQL

Jump Start MySQL

Timothy Boronczyk

Publisher Resources

ISBN: 0672323923Purchase book