I appreciate all the help I've been getting but I still have the same problem.
I'm using php with mysql. The script that I am using is
[PRev] 1-2-3 [NEXT] for my search results.
I know that there are two select statements that are used in the script. One to get the count of results and the other to produce my results.
When I leave the select statements like this:
(simplified)
select * from $table;
everything works fine. I get the correct amount of resutls, the results per page are correct, and all the links at the bottom to the next page of results works fine.
When I change the select statements to something like this:
(simplified)
select * from $table where name = '$name' etc...
I get the correct amount of results, the number of results for the first page is correct, but when I click on a link to go to the next page of results I get "0 results found". I know there are more results to be seen.
I've tried four different scripts that I have found on this site and I get the same exact thing from all four of them. Perhaps I am leaving something out?
The problem seems to be somewhere with the "WHERE" statement. I think.
Anyway, here is the link to the scripts I have been trying. Thanks in advance for any help.
http://phpbuilder.com/snippet/detail.php?type=snippet&id=21
