mysql help

[soniclnd]

can anybody show me an example of how i would use the mysql function mysql_store_result()?..... i've been looking and i haven't found any examples, and i can't understand how they explain the structure of it on the mysql documentation (http://dev.mysql.com/doc/mysql/en/my...re-result.html) they tell me this:
MYSQL_RES *mysql_store_result(MYSQL *mysql)
but i dont understand wat that means....
could u please also explain how to use mysql_stmt_data_seek()... they describe it as
void mysql_stmt_data_seek(MYSQL_STMT *stmt, my_ulonglong offset)
but i dont understand that either....
can anybody help?

[MetalSkin]

MYSQL_RES * mysql_store_result(MYSQL * mysql)

means that you parse in a pointer to a MYSQL instance and you get back a pointer to a MYSQL_RES instance. I presume that they are structs, but not sure without checking the doco.

I'll do a search after lunch for an example for you.

The second one is similar to a standard seek function... so:

void mysql_stmt_data_seek(MYSQL_STMT *stmt, my_ulonglong offset)

means parse in a pointer to a MYSQL_STMT instance and the offset, i presume the offset is how far you wish to seek, ie. the length.

Again, I'll finish off my lunch and then search for an example for you.

[edit] - finished my lunch.

did a quick search for the command and example... found the page:

http://snowhite.cis.uoguelph.ca/~wineberg/...QL_example.html

as you can see, the result set from the query is stored by calling mysql_store_result. The param is the connection and the returned value is the result set.

You use the result set to iterate through all the returned sets of data from the query. i think the example shows it quite clearly, so I wont post the example. If you have any questions about it, just add a post to this thread.


ahh, the function mysql_stmt_data_seek is used to seek to a specific result in the result set from your query. the example thats in the link above doesn't use it, mainly because not many people would. unless you have a specific need for it (which one doesn't come to mind immediatly) then i wouldn't worry about it.

[soniclnd]

ok, thanx.... i really appreciate it....