Problem with Like "%abcd%" in IF statement

[azaidi]

Hi

I am using the IF statement below to test if the SET datatype
field in my table called "category" includes "mba" in the string. It does, because I inserted it previously using the checkbox array. But the use of LIKE immediately produces a parse error

<input type="checkbox" name="category_array[]" value="mba" <?php
if($myrow["category"] LIKE "%mba%"){echo " CHECKED";}?>>

What am I doing wrong?

Thanks

[sid]

you are mixing php and mysql syntax... use:

<input type="checkbox" name="category_array[]" value="mba" 
<?php 
if (eregi("mba", $myrow["category"])) {
    echo " CHECKED";
}?>

if you want the comparison to be case sensitive use ereg() instead.

http://www.php.net/manual/en/function.eregi.php

[azaidi]

Thank you for your advice. It's fixed my problem. You make newbies like myself want to learn more and help others in the forum when I can