Re: Exact equivalent of mysql_data_seek() in PEAR DB

On 2/8/06, Justin Patrin <papercrane@gmail.com> wrote: > Why? You can iterate through the results normally already. I suggest > either changing your login to loop through the data only once or > looking into perhaps MDB2 (I'm not sure if this is supported in it, > but it is worth a look). Well, it's just that I perform the query once, and then walk through the recordset three times to build up some <select> objects and some JavaScript case structures in order to support all of the requisite dymanic interactivity on my form. It's all happening within the same display fuse (I'm using Fusebox 4 for PHP). I solved the issue by calling fetchRow() with the 0 row number first, printing out the first HTML element individually, and THEN dropping into a while loop, calling fetchRow() normally. I don't like it, but it works. I'll have a look at MDB2. Thanks, -Christopher