[RESOLVED] Search Help

[stebut05]

Hi all,

I hope someone can help me please. I would like to add a search engine to a website. I want the user to be able to enter a search string that will search the db and output results. I am using InnoDB tables so i am unable to do a full text search. I have tried using a SELECT statement:

SELECT * FROM Table where name LIKE 'searchstring%', but all i get is all the records displayed. I hope someone can help and thanks for any help, advice and suggestion given in advance.

Ste

[maxpup979]

sounds like the search string isnt passing into the query. post code please

[Roger_Ramjet]

stebut05 you have this in the general help forum as well.

DO NOT DOUBLE POST PLEASE - IT IS RUDE AND WILL EARN YOU A BAD REPUTATION. and that will mean no help from the regulars.