Ok, here's the situation...
I am creating a search for a library so that the library's inventory can be searched online. All the inventory is inserted into a MySQL database. The search is created.
I have set it up so that it runs the search on the database and gets a count of how many results it found. Then depending on the count it sets up the "page" navigation for the results. (displaying 10 results per page)
Here is where the problem occurs...
I believe it has to do with how many entries are in the database, but I am not sure.
When the search repeats to display the results I get this message :
Warning: MySQL: Unable to save result set in /home/www/mysite/search/search.php on line 60 🙁
Line 60 is :
$srch_result= mysql_query($srch_db,$connection) or die ("Can not connect to DB");
There are a total of 66,033 entries currently in the library's database.:eek:
Anyway...it works the first time to setup the page navigation, but not the second time to display the results. After reviewing my code and came to the conclusion that there is "nothing" wrong with my code (I say nothing, but obviously there is something wrong with it), I removed the code that displays the results and simply duplicated the result count code and "page" navigation display, and received the same error.
So, any advice on how to prevent this from happening?
I would appreciate it, thanks.
Ryan
