[PHP-DB] RE: Pulling a long list of data stalls PHP

2002-01-10 Thread Peter Westergaard
At 08:03 AM 1/9/2002 -0800, Max wrote: Just curious, but which version of PHP are you using, the ISAPI or CGI. I've tried the isapi version before and had problems like this. PHP would crash and leave orphaned instances of php. If your using the isapi version try the cgi and see if it works

[PHP-DB] Re: Pulling a long list of data stalls PHP (SOLVED!)

2002-01-09 Thread Peter Westergaard
Thanks to Miles! The problem, for anyone who is going through this themselves lay (in my case) with my php.ini file - evidently my fat fingers copied the 'recommended' php.ini file, instead of the 'distro' php.ini file. The 'Recommended' file contains a few optimizations and security

[PHP-DB] RE: Pulling a long list of data stalls PHP

2002-01-09 Thread Max Sullivan
Just curious, but which version of PHP are you using, the ISAPI or CGI. I've tried the isapi version before and had problems like this. PHP would crash and leave orphaned instances of php. If your using the isapi version try the cgi and see if it works for you. -Original Message-

[PHP-DB] Re: Pulling a long list of data stalls PHP

2002-01-09 Thread Ian Ferger
try mysql_fetch_array... mysql_fetch_row is a crappy old function. - Original Message - From: Peter Westergaard [EMAIL PROTECTED] Newsgroups: php.db To: [EMAIL PROTECTED] Sent: Monday, January 07, 2002 8:32 AM Subject: Pulling a long list of data stalls PHP Hi, I'm

[PHP-DB] Re: Pulling a long list of data stalls PHP

2002-01-08 Thread Peter Westergaard
Miles, you wrote: Is your table indexed on the field your query is based on? That will greatly speed up the query. Miles Thompson I'm afraid in my case, the query needs to be pretty much a complete table dump. Even if I filter a subset the data, my relational DB experience (not deep,

Re: [PHP-DB] Re: Pulling a long list of data stalls PHP

2002-01-08 Thread Miles Thompson
Peter, That's not right, but please forgive me if there is some background I've misplaced and I'm asking old questions. What OS are you on? What database? (I'm assuming MySQL, just because it's so common.) What version of the database? What version of PHP? Can you execute your SELECT at

Re: [PHP-DB] Re: Pulling a long list of data stalls PHP

2002-01-08 Thread Miles Thompson
Something more ... 1. Put something like this in your code where you execute the query $ result = mysql_queyr($sql) or die( mysql_errno(). : .mysql_error()); 2. If the query is succesful, just dump the result w/o any formatting, just in case the problem's there. (Shouldn't be with IE, it's

Re: [PHP-DB] Re: Pulling a long list of data stalls PHP [_SOLVED_]

2002-01-08 Thread Peter Westergaard
Thanks to Miles! The problem, for anyone who is going through this themselves lay (in my case) with my php.ini file - evidently my fat fingers copied the 'recommended' php.ini file, instead of the 'distro' php.ini file. The 'Recommended' file contains a few optimizations and security patches,