Does anyone have any suggestions on creating a simple search mechanism using PHP & MySQL? If you could make it simpler that'd be great. Ideally I'd like not to use any 3rd party software, but am open to suggestions. Please attach any helpful URL's if possible.

Thanks

Hi,

You can search for an expression using SELECT FROM LIKE '%$search%'. It selects all rows containings the word $search. Very basic but it just works fine for me.

Here are some tutorials I advice you to read :
codewalkers.com - Creating a Search Application (by Matt Wade) : codewalkers.com/tutorials/46/1.html
devarticles.com - Developing a Dynamic Document Search in PHP Part 1/2 (by Murali Dharan) : www.devarticles.com/art/1/599/1

I also know 2 other good tutorials but... in french sorry <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>. Check out the premium tuts, maybe there's something for you !

Hope it helps.

Edited by - goa103 on 10 Nov 2008 00:26:50