#20901 [Fbk->Opn]: Query to MySQL hangs for 90sec from Netscape 4.08

ID: 20901 User updated by: judd@ob-wan.com Reported By: judd@ob-wan.com -Status: Feedback +Status: Open Bug Type: Performance problem Operating System: Win2K Server PHP Version: 4.2.3 New Comment: Try this one, it really takes ages: function verify_login($username, $password) { /* verify the username and password. if it is a valid login, return an array * with the username, firstname, lastname, and email address of the user */ $qid = db_query(" SELECT username, firstname, lastname, email, priv FROM users WHERE username = '$username' AND password = '" . md5($password) . "' "); return db_fetch_array($qid); } Previous Comments: ------------------------------------------------------------------------ [2002-12-09 06:21:52] msopacua@php.net Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.php.net/how-to-report.php If you can provide more information, feel free to add it to this bug and change the status back to "Open". Thank you for your interest in PHP. AFAIK, no browser is able to access MySQL, so some example code would be pleasant. ------------------------------------------------------------------------ [2002-12-09 06:04:06] judd@ob-wan.com Querying MySQL takes an awfully long time from Netscape. I am running 4.08 and cannot comment about other versions. IE 5.5 does not display this problem. A clue to debugging this is that changing focus after the query brings the result back immediately. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=20901&edit=1