I am looking for the best way to use the wildcard % witha php variable...I am trying to create a site searc feature and I think the wildcard is the answer. I have tried just about every combination in the query and have been unable to get it to work...any help would be appreciated...thanks!
First off...you are always on! I have visited many different times and you are always responding(quick)....for that I thank you!
as for te wildcard I am setting up a select * from TABLE where var like '$searchVar%'...., but of course this has not worked...I have tried to search for an example of code doing a similar search with a variable, but no luck!
Have you echoed the query to determine if it appears correct? Have you run this resulting query directly against the database with a known working interface?