conditional operator (if) 'like' values in an array

[laurus]

I have an result set "$row_subcat"

I need to place a check in a checkbox if the value of the checkbox was selected (stored in a database).

I think it should be something like ;

if($row_subcat contains "Uncut")

but I can't find the syntax to do this with PHP. It would be like the 'in' operator with sql.

thanks!

[laurus]

I am getting closer but this only checks one box even if multiple were pulled from the database

$query = "SELECT subcat_name from subcat2photo where asset_id = '".$asset_id."' ";
$r_sc = mysql_query($query) or die('Query failed: ' . mysql_error());
$row_sc = mysql_fetch_assoc($r_sc);

if(preg_match ("/a value/", $row_sc["subcat_name"]))

[leatherback]

Hi Laurus,
Not sure how you store your info. In these cases I use this structure:

One table with the keywords:
<id><label>

On table with the data
<id><..>

One table between them:
<keyword_id><data_id>

That allows you to query all the keywords for a certain datatype (Taken from my script linking keywords to pictures):

// ------------- Get themes -------------------------------------------------
$ThemeResult = mysql_query("select * from ImgToTheme where I_F_Nr = $id");
  while($ThemeRow = mysql_fetch_array($ThemeResult))
    {
    $ThemeSelected[$ThemeRow['I_T_Nr']] = " checked ";
    }

and when you retrieve all the themes later on, to create all the checkboxes you use this info:

// ------------- Themelist ----------------------------------------------

$themeresult = mysql_query("select * from theme");
    while ($theme = mysql_fetch_array($themeresult))
      {
      $themelist .= "<input type=checkbox ".$ThemeSelected[$theme['T_Id']]." name=Theme[] value=".$theme['T_Id'].">".$theme['T_Theme']."<br>
      ";
      }

[aksival]

A simple, effective, yet somewhat sloppy method I've used before to validate any given number of permission sets is to encapsulate each one in < > and dump them all in a string.

For example:

$permissions = "<THING_1><THING_2><THING_3><THING_4>";

and then use something like this to detect it:

if( stristr($permissions, "<THING_3>") ) $something = true; else $something = false;

It's one way...probably not the most effective way, but it's worked flawlessly for me thus far.

Just a thought...it may or may not help you.

[ed_hamilton]

Thanks leatherback,
I've been stumbling with the checks on selected boxes for some time. Now I need to make this display in three columns. Any help would be appreciated.

[bradgrafelman]

For the columns, search the board - that type of thing has been covered many times (in fact, Weedpacket even submitted a generic code example... it may have been in Code Critique, though I don't recall).

As for the issue at hand... did you get it resolved with one of the above suggestions? If so, don't forget to mark this thread resolved.

[ed_hamilton]

My problem has been resolved but since this thread was started by laurus, I'm not sure it would be appropriate for me to mark this resolved.

As for the problem of columns I'll search other threads, thanks.

[bradgrafelman]

Woops, didn't notice that this was an old thread.