Search Options

[Neil Humphrey]

Is there a way to search by wildcard ?
At the moment my search works but only if I put in the exact name of waht I am searching for ! (Which kinda defeats the object in my opinion).

Is there a way to search with wildcards please ?

[Jack T]

Hey Neil,

you can do the following:

$srch="%".$fieldname."%";
$querysearch = "select * from tablename where fieldname LIKE '$srch' ";

if you enter A in the search box, it'll search for anything with a letter A in the name.

If you take out "%". and this will give you anything that start with letter A.

play around with it and you'll see what I mean.

Hope this helps.
JT