I have created a very small and simple search script for my website, The user will type in what ‘word’ he/she is searching for. This form will then take them to a script that will search in the database/table for everything that contains that word.
The problem I have is that let’s say for example somebody is searching for info that contains the word ‘fun’. I think you would then search your database with %fun%.
But what if somebody searches with the word ‘f’. Won’t it come up with every bit of data that has a ‘f’ in the name? I can’t change it to just %fun or fun% cause that wouldn’t show all the correct info.
I’m stuck as to what I need to do so that if someone searches for ‘fun’ it shoes all the right info and if someone searches for ‘f’ it will come up with the error message.
I’m a bit confused. I hope my message makes sense. I would really appreciate some help.:sure::sure::sure:
