Cannot get simple search form to work in DW CS6 on my Mac

It's been awhile since I tried using Webassist to build a simple PHP/MySQL search form and cannot get it to work. would you take a quick peek and see what I'm doing wrong? I'm attaching the page.

You are trying to search a recordset with the value from the recordset instead of using the form element.

Instead of:

$rsSeach->bindParam("c", "".($rsSeach->getColumnVal("files"))  ."", "-1xxx"); //varKeyword

it should be:

$rsSeach->bindParam("c", "".(isset($_GET["keyword"])?$_GET["keyword"]:"")  ."", "-1xxx"); //varKeyword

How do I make the MySQL search case-insensitive? e.g, the keyword 'bylaws' won't find the file Bylaws.pdf but the keyword 'Bylaws' does. I know it is an issue on a LInux server but I've never had a case sensitivity issue before on my Mac. Since there are several hundred files in the database that are camel-case, I'd like to make the search case-insenestive.

Any ideas on what I might try?

Update the collation value in your table directly for that column. Anything that ends in "_ci" is "case-insensitive".

I usually use: utf8_general_ci