strpos quesiton

[shackwm60]

This will be an easy one for you guys...

 

One of the fields in a MySQL database is a varchar() that was populated using a checkbox method and can contain more than one response. in this case i have blue, yellow, green and want to check if the field contains blue before echoing the statement to the screen. How would i use strpos in this case? ive tried a few thigns and get syntax error. The below of course works if the field ONLY contains blue.

 if (($row['colorsyoulike']) =='blue') {
   echo "<tr>";
   echo "<td>Blue is an available Color!</td>";
 
}

 

thanks.

[CroNiX]

if (strpos($row['colorsyoulike'], 'blue') !== FALSE)
{
  //$row['colorsyoulike'] contained 'blue' somewhere in the string
}

strpos() will return boolean FALSE if the string isn't contained in the search string.

 

However, it would probably be better to use stripos() which is case-insensitive, so it will match blue, BLUE, Blue, BlUe etc.

[mac_gyver]

or you could just normalize the data, storing each value in its own row in a database table and let the database do all the work when inserting, finding, or deleting any of data without needing a bunch of php code.

[shackwm60]

Thanks Cronix.. that did it. I was way off.

 

Unfortunately mac-gyver the db has existed for a while and theeres numerous instances like this one.  i am just making changes for someone. thanks for the input.