Link to home
Start Free TrialLog in
Avatar of geist62
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!
Avatar of Lemuel Aceron
Lemuel Aceron
Flag of Singapore image

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?!
Giving the query and related code, as eulac suggested, would be very helpful.
Avatar of geist62
geist62

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
Avatar of geist62
geist62

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial