Re: MySQL 3.23.10 Help

First Let me thank you Graeme Merrall for ur kind reply. The reason why I am getting above 3000 records is because those are search results quite similar to other search engines. In the mean time I have asked my web hosting company to check for the latest MySQL version, as u have pointed out. I have also told them to change some mysql sytem variables. Let see Thanks & Regards Ravi Graeme Merrall wrote: > On Mon, Oct 23, 2000 at 11:24:56AM +0530, ravi wrote: > > Hello Everybody, > > > > The Mysql version I am using is 3.23.10 alpha on Redhat Linux 6.0 > > > > I keep getting this error "Warning: Supplied argument is not a valid MySQL result > > resource in > > searchresult.php3 file on line 98". This error I found mainly comes when the result > > of my database search > > is greater than 3000 approximate records. If the search result is less than 3000 or so > > then all the results > > are shown page by page. > > > > Hi. > Check the mySQL manual on tuning procedures although I'd be asking myself > why 3000 records need ro be returned! :) > Also, *please* upgrade your version of mySQL. It may be due to your alpha > software. The latest version is 3.23.26-gamma > > Cheers, > Graeme > > -- > Turn on, dial in, geek out...