php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #18010 mysql_query hangs when request to return multiple columns occours
Submitted: 2002-06-27 02:24 UTC Modified: 2002-06-28 02:06 UTC
From: dave_bachtel at yahoo dot com Assigned:
Status: Not a bug Package: MySQL related
PHP Version: 4.2.1 OS: PHP=FreeBSD/Apache mySQL=WinXP
Private report: No CVE-ID: None
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: dave_bachtel at yahoo dot com
New email:
PHP Version: OS:

 

 [2002-06-27 02:24 UTC] dave_bachtel at yahoo dot com
Ok, this works:
$result = mysql_query("select server from ftpsearch where fullurl like '$query'");

The following queries do not work:
1.)
$result = mysql_query("select server, fullurl from ftpsearch where fullurl like '$query'");
2.)
$result = mysql_query("select * from ftpsearch where fullurl like '$query'");

Basically, any request asking for multiple columns to be return fails miserably.  Both of these statements work fine when using the mysql.exe client, so I know they are syntactically correct.

When two or more colums are requested, it hangs.  Not even the html at the top of the page is displayed.

The server running PHP is hosted remotely, I have no access to it.  The server running mySQL is with me, so I can modify and change it if necessary.

Thx,
-dave-

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2002-06-28 01:54 UTC] dave_bachtel at yahoo dot com
Ok, changed to a different SQL server (same one hosting the php) and I had no problems.  Still any idea of what was causing that?  Could be XP?
-dave-
 [2002-06-28 02:06 UTC] sniper@php.net
It's not likely to be any bug in PHP. Propably some misconfiguration, etc. Better ask mysql folks anyway.


 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Sat May 04 20:01:32 2024 UTC