Search Array if already exists than don't echo

SpecialFX

I have a field that has picture tags in it, so some of them are the same as other tag rows, however I don't want to repeat all the tags over and over. So I want it to check and see if that tag was already echoed and if it was then don't echo it again.

So I tried storing them in an array then searching the array for that value, however it didn't work at all... it is continuing to echo them regardless of being in the array or not. Any ideas?

Also, the field they are pulling from is like this: these are, some, of my, tags, for, my, picture.

<?
	require('../dbconnect.php');

$sql = "SELECT * FROM my_table";
$rs = mysql_query($sql);


 while($data = mysql_fetch_assoc($rs)) {
	$info = stripslashes($data['tags']);

$entry = explode(",", $info);
$total = count($entry);
$check   = array();    

  for($i=0; $i< $total; $i++){ 
	$current = strtolower(trim($entry[$i]));       
	$current_show = ucwords($current);

	if(!in_array($current, $check)){                                                                                       
      echo "'".$current_show."',";                                             
      $check[$i.$current] = $current;                                
	}
  }

   } 



?>

firemankurt

I rewrote a little bit to try simplify it but I don't think this will solve your problem yet.

Can you show some output from your script or some of your data so we can see why "in_array($current, $check)" seems to evaluate the way it does?

<?
    require('../dbconnect.php');

$sql = "SELECT * FROM my_table";
$rs = mysql_query($sql);


while($data = mysql_fetch_assoc($rs)) 
   {
      $info = stripslashes($data['tags']);

  $entry = explode(",", $info);
  $total = count($entry);
  $check   = array();    

  foreach($entry as $tag)
  {
    $curTag = strtolower(trim($tag));       
    $current_show = ucwords($curTag);

    if(!in_array($curTag, $check))
    {                                                                                       
      echo "'".$current_show."',";                                             
      $check[] = $curTag;                                
    }
 }

   }
?>

SpecialFX

That exports something along the lines of:

'Syracuse','Shows','Piebald','Flyer','Show','Flyer','If Hope Dies','Show','Shows','Greene Reveal','Flyer',

Note: How 'Show', 'Shows', 'Flyer', are all repeated!

leatherback

Hm..

so much to say..

this:
$info = stripslashes($data['tags']);
shoud not be required. The slashes are needed to enter the values into the database. After that, they are 'gone', as your database interprets the slashes as a sign that a special char. is being inserted.

WHY do you stoer a list of tags in one field. You SHOULD store them in a separate table, using a link-table:
<images>
[id][nam]
<link>
[imgnr],tagnr]
,tags.
[id][name]
Which solves your problem in one step.

Anyway..

If you use the TAG as a key in an array:

....
$tags = array()
while(...)
  {
  $entry = explode(",", $info); 
  foreach($entry as $thistag)
    {
    $thistag = trim($thistag, 2);
    $tags[$thistag] = $thistag;
    }
  }
// debuggin:
print_r($tag);

//for real:
foreach($tags as $tag)
  {
  echo $tag;
  }

leatherback

oh yeah..

have a look at [man]array_unique[/man] if that didn't solve it

SpecialFX

That didn't solve it so I tried with array unique and came up with this, which partially works...It only does the first row.

<? 
    require('../dbconnect.php'); 

$sql = "SELECT * FROM sg_juice_projects";           
$rs = mysql_query($sql); 


while($data = mysql_fetch_assoc($rs)) 
   { 
      $info = stripslashes($data['tags']); 
      $entry = explode(",", $info); 
      $check = array();     

  foreach($entry as $tag) 
  { 
    $curTag = strtolower(trim($tag, 2));                                                                                                                                                  
    $check[$curTag] = $curTag;                                 
   }  
}   

$final_check = array_unique($check); 

 debug
//print_r($check);
//print "</br>";
//print_r($final_check);

foreach($final_check as $final_tag)
{
	echo "'".$final_tag."',";
}
?>