Bug #10983 Updated: php can't select database in mysql, so mysql is not working at all.

ID: 10983 User Update by: kim@dns.clickbiz.com.tw Status: Closed Bug Type: MySQL related Operating system: WINNT 4.0 PHP Version: 4.0.5 Description: php can't select database in mysql, so mysql is not working at all. sorry, but i was too mad to notice. let me rephrase the whole thing. After i upgrade php from 4.04p1 to 4.05 at WinNT machine, i couldn't get mysql query working at all. Technically, they all work, just i don't get any result back. example: <? echo "DATABASE: Healthy<BR>"; $query="select * from MEMBER"; $ident = mysql_connect("Kim","root","") or die("Bad query: ".mysql_error()); mysql_select_db("healthy"); $restult=mysql_db_query("healthy",$query); while ($row=mysql_fetch_array($result)) echo $row["serial"]; ?> and the result i got is: DATABASE: Healthy Warning: Supplied argument is not a valid MySQL result resource in d:\www\test\php\db.php on line 13 i can assure you that the member table is not empty. i have tried re-install php and apache, but they still don't work as they should. Previous Comments: --------------------------------------------------------------------------- [2001-05-21 06:02:59] cardinal@php.net Please read the bug submission guidelines. http://www.php.net/bugs-dos-and-donts.php This report lacks any details, especially an example script or error message. It's probably an issue with your script. Reopen the report with an example script and error messages, or ask one of the support mailing lists for assistance. http://www.php.net/support.php --------------------------------------------------------------------------- [2001-05-21 05:16:49] kim@dns.clickbiz.com.tw --------------------------------------------------------------------------- Full Bug description available at: http://bugs.php.net/?id=10983