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'" <mysql@lists.mysql.com> Sent: Tuesday, February 01, 2005 9:20 PM Subject: Problem 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 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] > > > > !DSPAM:41ffe4c9213322003044064! > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]