Search DB.

[shenniko]

Hi Guys need a little help,

Pretty new to MySQL and PHP, as i started learing ASP thought Access DB's...

Ive created a sort of search function for my members section, so you can search by Username..

How do you create a "LIKE" statement?

E.g say i enter Da into the search box, it will bring Everything back with "Da" in the database?

All i need is the

WHERE tblCharacter.Character LIKE '$Character'";

Or whatever the code is.

thanks in advance

shenn

[mshallop]

[!--quoteo(post=344455:date=Feb 10 2006, 05:31 AM:name=shenniko)--][div class=\'quotetop\']QUOTE(shenniko @ Feb 10 2006, 05:31 AM) [snapback]344455[/snapback][/div][div class=\'quotemain\'][!--quotec--]
Hi Guys need a little help,

Pretty new to MySQL and PHP, as i started learing ASP thought Access DB's...

Ive created a sort of search function for my members section, so you can search by Username..

How do you create a "LIKE" statement?

E.g say i enter Da into the search box, it will bring Everything back with "Da" in the database?

All i need is the

WHERE tblCharacter.Character LIKE '$Character'";

Or whatever the code is.

thanks in advance

shenn
[/quote]

WHERE tblCharacter.Character LIKE '%$Character%'";

if $Character == "da" and this is being submitted from somescript.php...

--Mike

[fenway]

If you are doing this often, you many want to consider using a FULLTEXT index.