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 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.*, propertyDataBulk.propertyDesc
> FROM propertyData LEFT JOIN propertyDataBulk ON propertyData.id =
> propertyDataBulk.propertyID WHERE state = 'CA' limit 0, 5
>
> Very odd that this happens, I am running MySQL 4.1.9
>
> Thanks,
>
> Matt Babineau
> Criticalcode
> w: http://www.criticalcode.com
> p: 858.733.0160
> e: [EMAIL PROTECTED]
--
- michael dykman
- [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
