help pls i want only to display unique other_skills

milo_pantig

foreach($other_skills as $os => $other_skills_1) {
foreach($status as $st => $status_1) {
if ( (strcasecmp($other_skills_1, $other_skills_1) == 0) ) {
echo "********other_skills : ".$other_skills_1."<br>";
}
// $sql_6 = "Insert into mmn_other_skills(mmn_id,other_skills,status)
// values('$row_id','$other_skills_1','0')";
// mysql_db_query($oClass->database_name,$sql_6) or die (mysql_error());
}
}

output

*****other_skills : Stage Actor/Actress
**other_skills : Stage Actor/Actress
**other_skills : Stage Actor/Actress
**other_skills : Stage Actor/Actress
**other_skills : Stage Actor/Actress
**other_skills : Stage Actor/Actress
**other_skills : Stage Actor/Actress
**other_skills : Stage Actor/Actress
**other_skills : Stage Actor/Actress
**other_skills : Stage Actor/Actress
**other_skills : Dancer (classic)
**other_skills : Dancer (classic)
**other_skills : Dancer (classic)
**other_skills : Dancer (classic)
**other_skills : Dancer (classic)
**other_skills : Dancer (classic)
**other_skills : Dancer (classic)
**other_skills : Dancer (classic)
**other_skills : Dancer (classic)
**other_skills : Dancer (classic)
**other_skills : TV Actor/Actress
**other_skills : TV Actor/Actress
**other_skills : TV Actor/Actress
**other_skills : TV Actor/Actress
**other_skills : TV Actor/Actress
**other_skills : TV Actor/Actress
**other_skills : TV Actor/Actress
**other_skills : TV Actor/Actress
**other_skills : TV Actor/Actress
**other_skills : TV Actor/Actress
**other_skills : Film Actor/Actress
**other_skills : Film Actor/Actress
**other_skills : Film Actor/Actress
**other_skills : Film Actor/Actress
**other_skills : Film Actor/Actress
**other_skills : Film Actor/Actress
**other_skills : Film Actor/Actress
**other_skills : Film Actor/Actress
**other_skills : Film Actor/Actress
*****other_skills : Film Actor/Actress

Kudose

<?php
$used = array();
foreach($other_skills as $os => $other_skills_1) {
  foreach($status as $st => $status_1) {
     if(!in_array($other_skills_1, $used)){
     $used[] = $other_skills_1;
      if ((strcasecmp($other_skills_1, $other_skills_1) == 0) ) {
        echo "********other_skills : ".$other_skills_1."<br>";
      }
      // $sql_6 = "Insert into mmn_other_skills(mmn_id,other_skills,status)
      // values('$row_id','$other_skills_1','0')";
      // mysql_db_query($oClass->database_name,$sql_6) or die (mysql_error());
    }
  }
}
?>

milo_pantig

other_skills : Stage Actor/Actress------0
other_skills : Stage Actor/Actress------0
other_skills : Stage Actor/Actress------0
other_skills : Stage Actor/Actress------0
other_skills : Stage Actor/Actress------0
other_skills : Stage Actor/Actress------0
other_skills : Stage Actor/Actress------0
other_skills : Stage Actor/Actress------0
other_skills : Stage Actor/Actress------0
other_skills : Stage Actor/Actress------1
other_skills : Dancer (classic)------0
other_skills : Dancer (classic)------0
other_skills : Dancer (classic)------0
other_skills : Dancer (classic)------0
other_skills : Dancer (classic)------0
other_skills : Dancer (classic)------0
other_skills : Dancer (classic)------0
other_skills : Dancer (classic)------0
other_skills : Dancer (classic)------0
other_skills : Dancer (classic)------1
other_skills : Film Actor/Actress------0
other_skills : Film Actor/Actress------0
other_skills : Film Actor/Actress------0
other_skills : Film Actor/Actress------0
other_skills : Film Actor/Actress------0
other_skills : Film Actor/Actress------0
other_skills : Film Actor/Actress------0
other_skills : Film Actor/Actress------0
other_skills : Film Actor/Actress------0
other_skills : Film Actor/Actress------1

milo_pantig

foreach($other_skills as $os => $other_skills_1) {
foreach($status as $st => $status_1) {
echo "other_skills : ".$other_skills_1."------".$status_1."<br>";
// $sql_6 = "Insert into mmn_other_skills(mmn_id,other_skills,status)
// values('$row_id','$other_skills_1','0')";
// mysql_db_query($oClass->database_name,$sql_6) or die (mysql_error());
}
}

Kudose

Did you try my code? If so, what was wrong with it that made you discard it?

milo_pantig

i send u the old code ..

Kudose

Updated for your second post of code (please use the [ PHP ] tags for your posts of code):

<?php
$used = array();
foreach($other_skills as $os => $other_skills_1) {
  foreach($status as $st => $status_1) {
    if(!in_array($status_1, $used)){
      $used[] = $status_1;
      echo "other_skills : ".$other_skills_1."------".$status_1."<br>";
      // $sql_6 = "Insert into mmn_other_skills(mmn_id,other_skills,status)
      // values('$row_id','$other_skills_1','0')";
      // mysql_db_query($oClass->database_name,$sql_6) or die (mysql_error());
    }
  }
}
?>

milo_pantig

its working man but i need to include
grouping of $status_1= 0 or 1

$status_1= ------0
$status_1= ------1

Kudose

What do you mean?

Do you want your output to look something like this:

other_skills : Stage Actor/Actress------0
other_skills : Dancer (classic)------1
other_skills : Film Actor/Actress------1

....just a single row for each returning the total entry count?