geist62
asked on
MySQL search sometimes returns all results
I have a search and results page. For the first time today, I noticed that when I search in the surname for a specific surname it returns every entery in my database. However a few minutes latter I return to conduct a new search and it works fine returning only the results I specify.
Any ideas why this would occur? Thanks!
Any ideas why this would occur? Thanks!
can you paste your search code with the sql statement here...
would surprise me alot.
I rather have to guess that your search/results pages do not save the value correct to be searched for, and search LIKE '%' eventually?!
I rather have to guess that your search/results pages do not save the value correct to be searched for, and search LIKE '%' eventually?!
Giving the query and related code, as eulac suggested, would be very helpful.
ASKER
I will post the code latter this afternoon. Thanks very much!
Also, which surname causes the issue? Does it have a space in it?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.