PHP Tutorials: Search Engine (Part 5/8)

[virgiltu]

This will fix it

$where .="name LIKE '%$keyword%'OR username LIKE '%$keyword%'";

and

$results = "SELECT * FROM users WHERE $where" ;

[UngawaMagic]

Dont forget the } under the echo $where; like i did.

[caophuongduy11]

Thank alot phpacademy. Just one word to say that is all of your tutorial is "AWESOME"

[ForfrontTechnology]

Ok? Remix... Very good tutorial videos. All the way!

[Misklahr]

Hum... I get $results_num = 0 when i echo $results_num. :S

[pukirocks]

@Misklahr did you find a way to solve the issue? i'm facing it too, i'm quite sure it has something to do with the sintaxis in $where.="`keywords` LIKE '%".$keyword."%'"; but i can't figure it out

[CanCan2623]

@pukirocks I removed the single quotation marks around the table and column names and it worked for me.

[vallonierproduction]

I chexk everything and I did everything, i still get no result, the code works but it doesn't call anything. :(

[WebTutsHD]

Your vids are just great . Help me alot

[Malasuerte94]

You can do a tutorial, if you stay online when you get a number of points? And the points are gathered to "buy" various items