Re: [PHP] RE: Problem with SELECT SQL_CALC_FOUND_ROWS

2005-02-02 Thread Richard Lynch
Matt Babineau wrote: > Ok I installed PHP 4.3.10 and it still has not fixed the problem. If I > remove the SQL_CALC_FOUND_ROWS from the query, it works no problems! This > is > very strange behavior! Not really that strange, I think... While you might want to read this: http://us4.php.net/manual

Re: Problem with SELECT SQL_CALC_FOUND_ROWS

2005-02-02 Thread Jigal van Hemert
A quick look at the PHP site... http://www.php.net/manual/en/faq.databases.php#faq.databases.upgraded Regards, Jigal. - Original Message - From: "Matt Babineau" <[EMAIL PROTECTED]> To: "'MySQL General'" Sent: Tuesday, February 01, 2005

RE: Problem with SELECT SQL_CALC_FOUND_ROWS

2005-02-01 Thread Matt Babineau
: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 01, 2005 3:55 PM To: Michael Dykman Cc: Matt Babineau; 'MySQL General' Subject: Re: Problem with SELECT SQL_CALC_FOUND_ROWS I'm confused. That bug was closed over 2 years ago. What makes you think it applies here, and

Re: Problem with SELECT SQL_CALC_FOUND_ROWS

2005-02-01 Thread Michael Stassen
e what happens? Matt Babineau Criticalcode w: http://www.criticalcode.com p: 858.733.0160 e: [EMAIL PROTECTED] -Original Message- From: Michael Dykman [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 01, 2005 12:47 PM To: Matt Babineau Cc: 'MySQL General' Subject: Re: Problem with SE

RE: Problem with SELECT SQL_CALC_FOUND_ROWS

2005-02-01 Thread Michael Dykman
al Message- > From: Michael Dykman [mailto:[EMAIL PROTECTED] > Sent: Tuesday, February 01, 2005 12:47 PM > To: Matt Babineau > Cc: 'MySQL General' > Subject: Re: Problem with SELECT SQL_CALC_FOUND_ROWS > > Matt, > > I suspect your problem is PHP, not My

RE: Problem with SELECT SQL_CALC_FOUND_ROWS

2005-02-01 Thread Matt Babineau
- From: Matt Babineau [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 01, 2005 12:52 PM To: 'Michael Dykman' Cc: 'MySQL General' Subject: RE: Problem with SELECT SQL_CALC_FOUND_ROWS Weird thing is that I am running PHP 4.3.9I guess I can upgrade and see what happ

RE: Problem with SELECT SQL_CALC_FOUND_ROWS

2005-02-01 Thread Matt Babineau
:47 PM To: Matt Babineau Cc: 'MySQL General' Subject: Re: Problem with SELECT SQL_CALC_FOUND_ROWS Matt, I suspect your problem is PHP, not MySQL. refer to http://bugs.php.net/bug.php?id=16906&edit=1 On Tue, 2005-02-01 at 15:20, Matt Babineau wrote: > Hi All- > &

Re: Problem with SELECT SQL_CALC_FOUND_ROWS

2005-02-01 Thread Michael Dykman
Matt, I suspect your problem is PHP, not MySQL. refer to http://bugs.php.net/bug.php?id=16906&edit=1 On Tue, 2005-02-01 at 15:20, Matt Babineau wrote: > Hi All- > > I'm running a query that uses SQL_CALC_FOUND_ROWS for my search engine on a > real estate site. The problem is that I get

RE: Problem with SELECT SQL_CALC_FOUND_ROWS

2005-02-01 Thread Matt Babineau
ry(); statement. Matt Babineau Criticalcode w: http://www.criticalcode.com <http://www.criticalcode.com/> p: 858.733.0160 e: [EMAIL PROTECTED] _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 01, 2005 12:25 PM To: Matt Babineau Cc: 'MySQL

Re: Problem with SELECT SQL_CALC_FOUND_ROWS

2005-02-01 Thread SGreen
"Matt Babineau" <[EMAIL PROTECTED]> wrote on 02/01/2005 03:20:49 PM: > Hi All- > > I'm running a query that uses SQL_CALC_FOUND_ROWS for my search engine on a > real estate site. The problem is that I get an error when I run my query: > > "Warning mysql_query(): Unable to save result set in /

Problem with SELECT SQL_CALC_FOUND_ROWS

2005-02-01 Thread Matt Babineau
Hi All- I'm running a query that uses SQL_CALC_FOUND_ROWS for my search engine on a real estate site. The problem is that I get an error when I run my query: "Warning mysql_query(): Unable to save result set in /clients/search.php" My Query is: SELECT SQL_CALC_FOUND_ROWS propertyData.*, propert