database class

[Anon]

I am using a database class, when I do the connect a value is inserted in my variable $conn then I can do a query and it works fine. The problem is that the next time I have to reconnect to run a new query. The $conn variable looses its value. Even if I just do an open, then a query and try to close the connect it will give the same problem. Have anybody else seen this problem or know why its happening?

[Anon]

I found out that odbc_exec changes the value of $conn.
e.g
$conn = odbc_connect("name","user","pass");
now $conn = Resource id#1
odbc_exec($conn,$query)
now $conn = Resource id#3

this is obviously the problem but does anybody know if I to reconnect each time or is there a way around this.

thanks for any help.

[Anon]

odbc_pconnect() opens a persistent connection that survives the end of a script

(but not when PHP is run as CGI)

[Anon]

I tried that but i still have to reconnect after each odbc_exec. It seems that it you only need to reconnect after executing an insert or delete or update. After a select I don't have to reconnect. Have you any other ideas?