How to pass mysql results to another page

[bdlooze]

First, would it save a significant amount of access time for a website on a shared server to access a database once, and then try to pass that result on to the following pages. Or would it make more sense just to access the database each time the page is loaded or a new page is loaded (i.e. re-query the database for the same information).

Second, how would I encode or pass the result data from one php page to another? Can you do this through a form, or session?? Thank you,

ADDITION: Im trying to add the actual query result, not just a specific value....the result comes in as an identifier (a number, i.e.e result identifier #2)....I need to pass the whole result...

[adrian_quah]

there's at least 3 ways to do it: -

1. forms
2. sessions (yes, but may not be the best)
3. by via URL...

It can be easily done using forms...U can use Hidden fields.

The basic format is: -

<form name="PassVariables" type="post" action="PageTwo.php">
<input type="hidden" name="Variable1" value="ValueFromQuery">
</form>

Please note that 'ValueFromQuery' shd be something like
"<?php echo $query_result[0]; ?>" where $query_result is the Array variable to display the results from the query to ur db.

Then on the next page, PageTwo.php, u can try to see if the results are correct by:

echo $Variable1;

Hope i have helped, not add 2 ur confusion..