Caching a query

[amrigo]

Hi i have a system that control car acidents ..

I have a query that return the streets from a choosed city, after i ask if the crash happens in street crossing,

If so i do the same query to return the same streets to the user choose the street crossing.

I only need assign diferent variables names.

Is there any way to not go to the database to do the same work that already is done?

thanks in advance

[nemonoman]

If you have already captured this data, why not display it in the browser window? Am I missing something?

[superwormy]

Maybe you're looking for www.php.net/mysql_data_seek or a way to preseve resources over multiple pages... which you can't really do without some work.

You can extract it into a big multidimensional array and serialize() it, save it to a file, then load it and unserialize() next time you need it.

MySQL does some of its own automated query caching too.

[amrigo]

I do use mysql in some projects but this one i forgot to mention that i am using oracle

Can i serialize and unserialize ?

How is it done?

Thank´s in advance