with SELECT SQL_CALC_FOUND_ROWS
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
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:
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.*,
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
://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 General'
Subject: Re: Problem with SELECT SQL_CALC_FOUND_ROWS
Matt
Matt,
I suspect your problem is PHP, not MySQL. refer to
http://bugs.php.net/bug.php?id=16906edit=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 an
: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=16906edit=1
On Tue, 2005-02-01 at 15:20, Matt Babineau wrote:
Hi All-
I'm running a query
-
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 happens?
Matt Babineau
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 MySQL. refer to
http://bugs.php.net/bug.php?id=16906edit=1
On Tue, 2005-02-01 at 15:20, Matt
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 SELECT SQL_CALC_FOUND_ROWS
Matt
: 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 why do you say
11 matches
Mail list logo