hi people,
BACKGROUND:
I am accessing MySQL several times under different result_identifiers on the same page. I call one query, pull one row from it and do some things. From there I might do another query if certain value is true, otherwise kepp pulling out more rows. All the while checking for certain true value.
PROBLEM: When I go back to previous result_identifiers I am able to get more records, but it seems as though the MySQL internal pointer is being reset back to the first row.
Could someone please explain why this might happen or a way to use mysql_data_seek() to combat this.
Thanks
Darin
BACKGROUND:
I am accessing MySQL several times under different result_identifiers on the same page. I call one query, pull one row from it and do some things. From there I might do another query if certain value is true, otherwise kepp pulling out more rows. All the while checking for certain true value.
PROBLEM: When I go back to previous result_identifiers I am able to get more records, but it seems as though the MySQL internal pointer is being reset back to the first row.
Could someone please explain why this might happen or a way to use mysql_data_seek() to combat this.
Thanks
Darin