Storing Recordset in session variable

[Anon]

Hi!

I have been using PHP for a couple off days now and is really enjoying the experience so far.
There is something that i cant get to work and need some help with..please.
I am retrieving som records from a database, if there are a lot of post beeing returned i want to show them 5 at the time.
And since i dont want to ask the same question to the database each time the user click´s next or previous i want to store them in a session variable.
I tried something like this.
<?php
session_register ("rssokning");
?>

<?
if (($COMMAND<>'')and ($rssokning<>'')){
$result = $rssokning;
}
else{
$result = $db->Execute($strSQL);
$rssokning = $result
}
presents the result

and writes a link
<?
print "<a target='mainright' href='sok.php?<?=SID?>&CMD=move&POS=".($ABSPOS+$MAXONPAGE)."&name=".$strName."&www=".$strWww."&city=".$strCity."'><b>Nästa >></a>";
?>

This off course is not the complete code but i hope that it is enough for you to understand what i´m trying to do.

[toma42]

Do a search before posting or at least try to look for other stuff. It saves a lot of time.

http://phpbuilder.com/columns/rod20000221.php3

[jblallement]

Hi,

You'd better avoid this kind of use of session vars, otherwise you're webserver will quickly run out of memory.
A well designed access to the db is not as consuming as it may seem.

[Anon]

Ok!
I will try to do a better search next time!
Thanks for your help Tom!
best regards
Magnus Güvenal