PHP Search

[MrCraig]

How is it i would code something so that it searches a database for words (basically a search bar)?

[Blob]

$sql = mysql_query( "SELECT * FROM `database` WHERE `fieldname` LIKE '%' . $search . '%' ");

should work.

[MrCraig]

$sql = mysql_query( "SELECT * FROM `database` WHERE `fieldname` LIKE '$search' ");

should work.

Thanks, Didnt know about the LIKE command

+REP if i can..

EDIT: Cant..

[RichardKnox]

You don't need to use the %
Plus if you want to search multiple fields use this:

$sql = mysql_query( "SELECT * FROM `database` WHERE `fieldname` LIKE  $search OR `fieldname2` LIKE  $search OR `fieldname3` LIKE  $search"); 

etc

[Blob]

You don't need to use the %
Plus if you want to search multiple fields use this:

$sql = mysql_query( "SELECT * FROM `database` WHERE `fieldname` LIKE  $search OR `fieldname2` LIKE  $search OR `fieldname3` LIKE  $search"); 

etc

If you have % it allows to search for the search to ignore the leading characters and the characters following the search string.

See

http://www.weberdev.com/ViewArticle.php3?ArticleID=81