Temporary tables problem

[misxa]

I manage to create temp table, but once the same page is refreshed, the function which tries to read the inserted rows returns 'table doesn't exist' error. It seems as though it gets lost on the way???

HELP.

[Drakla]

Unless you make a permanent connectiont then temporary tables are dumped at the end of the script - that's the point of them. They're only accessible by that script, too - if you have 10 scripts running at once all making temp tables called 'tempytabby' then each one has their own private version so there's no bumping heads.

Can you do whatever you need doing with the temp table in some commands after it's generated in the same script?

[misxa]

Look... I have many functions located in the same php file. One of the functions create temp tables if they do not exist. The second function inserts some data. The third function tries to read the inserted data, but temp tables seem to vanish somehow???

Help...

[Drakla]

Having all the functions in one script won't make a difference if they're not all called during the single execution of a script.

Run these three SQL commands and see if you get results returned - if you don't something definitely is wrong

create temporary table foo (name char(30) );

insert into foo values ('stew'),('curry'),('prawns');

select * from foo;