Searching a MySQL database using PHP

[badben]

Does anybody out there know a tutorial or good script to search a MySQL database for keywords using PHP?

Ben

[falko]

There are a few PHP-MySQL tutorials here: http://www.google.com/search?q=php+m...en-US:official


I haven't tried them, but they should get you started.
http://www.freewebmasterhelp.com/tutorials/phpmysql
http://www.webmonkey.com/webmonkey/p...tutorial4.html

[Destroyer]

I am not sure if you want to search one table or the whole db but here are some links that may help

http://www.devarticles.com/c/a/MySQL...-Capabilities/

http://www.tizag.com/mysqlTutorial/mysqlselect.php

[AaronDavison]

Hi

Wonderful info guys....The list of apps looks great.....and i thank u..


edit reason.
Links look like spam.
Sorry if I'm wrong.

[Angelito]

SELECT * FROM `PRODUCT`
WHERE Enabled=1 AND
(name LIKE '%".$_GET["searchstring"]."%' OR description LIKE '%".$_GET["searchstring"]."%' OR brief_description LIKE '%".$_GET["searchstring"]."%');

It should return any record with a matching string in either specified field.

Share your results if it works for you.

Angel

[hardy123]

http://www.tizag.com/mysqlTutorial/-It will surely help you.