sessions and temporary tables
| From: | Wilbert Enserink | Date: | Tue, 18 Jun 2002 09:21:39 +0000 |
| Subject: | sessions and temporary tables | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-102664@lists.php.net to get a copy of this message | ||
hi all,
i have this problem:
1) on the start of each script I call session_start()
2) on my search.php page I query an info-table, put the results in a temporary table called
$SID(=session_id()), and display the results. As a check I also query the table $SID and voila: the
results were indeed stored in this temporary table.
3) On my next page there is this checkbox which says: search within these results.
4) If this checkbox is checked I query the $SID table rather then the info table.
5) but now I get this error: Table 'dbname.ed61c337640e2b0ab8f3ffccb63f8597' doesn't
exist
as a check I print $SID on each page. and always it is the same SID, which makes sense cause
i'm still in the same session.
My Q: howcome mySQL is not able to find this temporary table anymore.... It seems to have destroyed
this table when leaving the search.php page, but that's a rather odd idea, cause I thought it
maintained while the session was still active...
any input is largely appreciated!
thx and regards,
Wilbert
-------------------------
Pas de Deux
Van Mierisstraat 25
2526 NM Den Haag
tel 070 4450855
fax 070 4450852
http://www.pdd.nl
info@pdd.nl
-------------------------