C API: mysql_fetch_row() 2

[JoSno]

Hi all,

I make a mysql query using mysql_query(..). I then use mysql_store_result(..) to get a MYSQL_RES *result_set. I then run mysql_fetch_row(..) repeatedly over the set to do something or other.

My question is is it possible to reset to the beginning of the MYSQL_RES *result_set so that I can run mysql_fetch_row(..) over it again later on?

Cheers!
Jo

 

[sleipnir214]

Have you looked at mysql_data_seek()?

Want the best answers? Ask the best questions:

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

TANSTAAFL!

 

[danielhozac]

[tt]mysql_row_seek(result_set, 0);[/tt]
should do it. See

http://www.mysql.com/doc/en/mysql_row_seek.html

for more information.

//Daniel

 

[JoSno]

Brilliant, just what I was after. Knew it would be there somewhere but buggered if I could find it!

Gold stars for both of you!

Jo