From: [EMAIL PROTECTED] Operating system: Debian Linux PHP version: 4.0.4pl1 PHP Bug Type: MySQL related Bug description: a script works on 2 servers I use, and doesn't work on a third one Dear Support, One of my project were must go to another server, and I got a trouble with my functions. I try to write a short code to explain it. This script works well on my computer, windows 98 se, php 4.0.3. Also works on debian a server, php 4.0.3. There is another debian server (that was php 4.0.3 too), and this script crashes on it. I tried to reinstall mysql, php (the new 4.0.4pl), apache, but that did not help. I show a short code: ------ <?php $base = mysql_connect('localhost','kepes','***'); // I have a password of course... mysql_select_db('KEPES'); $rows = mysql_query("SELECT * FROM ARTICLE_STATE ORDER BY article_state_id",$base); test(); $rows = mysql_query("SELECT * FROM ARTICLE_STATE ORDER BY article_state_id",$base); mysql_close($base); function query_more($query,$base) { $result = array(); $data = mysql_query($query,$base); while ($row = mysql_fetch_array($data)) { $result[] = $row; } // if ($result) { // mysql_free_result($data); // } return $result; } function test() { $base = mysql_connect('localhost','kepes','***'); mysql_select_db('KEPES'); $rows = query_more("SELECT * FROM ARTICLE_STATE ORDER BY article_state_id",$base); mysql_close($base); } ?> ----- That outputs nothing on my computer, nothing on the first debian server. That's ok. But this outputs on the server where I'd use it the below: "Warning: Supplied argument is not a valid MySQL result resource in /home/kepes/public_html/test/test5.php4 on line 16 Warning: 1 is not a valid MySQL-Link resource in /home/kepes/public_html/test/test5.php4 on line 10" I figured out this is if I use at least 2 mysql connections same time. Another interest thing, if I comment out the: --- while ($row = mysql_fetch_array($data)) { $result[] = $row; } --- part of script, this also works on the 2nd server (but I can't use that way of course). Because my db-scripts are based upon methods like above, I would like to know what the problem is. I include some php info. PHP Version 4.0.5-dev System Linux ditto 2.2.17 #1 Mon Dec 4 23:29:54 CET 2000 i686 unknown Build Date Dec 10 2000 Configure Command './configure' '--with-mysql' '--with-apxs' Server API Apache Virtual Directory Support disabled Configuration File (php.ini) Path /usr/local/lib ZEND_DEBUG disabled Thread Safety disabled --------- mysql MySQL Support enabled Active Persistent Links 0 Active Links 0 Client API version 3.23.22-beta MYSQL_INCLUDE MYSQL_LFLAGS MYSQL_LIBS Directive Local Value Master Value mysql.allow_persistent On On mysql.max_links Unlimited Unlimited mysql.max_persistent Unlimited Unlimited ----- Thank You, Mage -- Edit Bug report at: http://bugs.php.net/?id=8831&edit=1 -- PHP Development Mailing List <http://www.php.net/> To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]