|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2001-03-03 20:01 UTC] sniper@php.net
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Fri Oct 24 16:00:02 2025 UTC |
in file functions.inc: function func1($blabla) { $conn = mysql_connect ("host","user","pass"); mysql_select_db("db",$conn); $resset=mysql_query("SELECT a,b,c FROM ATable",$conn); mysql_close($conn); } ------------------- file index.php: include ("functions.inc"); $conn_main = mysql_connect ("host","user","pass"); mysql_select_db("db",$conn_main); $resset=mysql_query("SELECT a,b,c FROM ATable",$conn_main); <-- this statement works and returns a result func1($abc); <-- call defined function $resset=mysql_query("SELECT a,b,c FROM ATable",$conn_main); <-- after calling the above defined function i get an error: warning: 1 is not a valid mysql link resource mysql_close($conn_main); so thats the problem: i have a script that makes a mysql connection. i can select, update, insert aso. from the db. then i call a function that itself makes a connection to the same db, does something with it (works fine) closes the connection and returns. i dont use global or give the main connection as an argument, its just a plain standalone function. after calling the function the main script has lost its mysql connection (its no timeout since the function doesnt take long to execute). the same scripts work with PHP version 4.0.1pl2. both pcs have the same setup (apache 1.3.12, mysql 3.22.32, the rest as rpms from the distibution cds). its all the same except the php-version (both compiled with the standard options --with-apxs --with-mysql -> make -> make install)