Using Query Results Twice

[Anon]

Hi,

Whats the easiest way to do the above - I'm currently doing queries twice (or more often if needed), but there must be a more efficient way to do it so I can use the results twice.

Fraser

[crislewis]

If you want to use results twice in the same routine then look at mysql_reset() which allows you to reset the row pointer back to the first row. mysql_seek(0) will do the same. If you want to 'store' the results and use them later but in the meantime you have mysql_close()'d the connection then load the result set into a global array.

Cheers,

Cris

[Anon]

Hi,

Got it working with mysql_data_seek($data, 0),

Thanks.

Fraser