[SOS]a search for a database ,double click here
well im trying to do a search form for my database here is the code =>
name is the name of the column
anyway when i delete "%" the code works great but when i add them it douesnt work *!*
% is a wildcard, that should only be used for LIKE mysql searches...
The actual syntax for that is like so:
Edit: Meh young William, meh. Nothing else to add.
thanks it works but for exemple you search "aaa" , i want it to give me the result from database as "aa"
but it douesnt :o
it give "no result"
the % procent means that it replaces "anything" so for example you want to find a name ending with "Harrison" and you would search for "%Harrison". See the % in the beginning ?
Switch place of the % if you want to search for the name beginning with "Harrsion" as so "Harrison%". Catching on now ?
And if you want to search for a name containing "Harrison" then it would be "%Harrison%".
I belive you can use a ? questionmark for replacing a single char.
Correct me if im out on a limb here ?
And see Wildhoney and bluesaga´s post above.
I had trouble with the LIKE thing in my early days of MySQL queries to.
|All times are GMT. The time now is 10:08 PM.|
Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0