Thread: Comparing an Array against a DB

Your foreach line has the potential to break something: $tag and $tag is being used to mean two different things at the same time. PHP Code: foreach( $tag as $key => $value ) { $tag [ $key ] = "'" . mysql_real_escape_string ( $value ). "'" ; } $query = "Select tag_name from tags where tag_name in (" . join ( ',' , $tags ). ")"...

Weedpacket, thank you for your reply - however it seems to have confused me even more. Even after a sleep, it hasn't clicked. I've started fresh and here is where I am: PHP Code: if (isset( $_POST [ 'submit' ])) { $newtags = htmlentities ( $_POST [ 'tags' ]); // Grab tags created by user $separators = array( "." , ...

Like I said, collect the returned tag names into their own array: PHP Code: $existing_tags = array(); while ( $currenttags = mysql_fetch_array ( $gettags , MYSQL_ASSOC )) { $existing_tags [] = $currenttags [ 'tag_name' ]; } print_r ( $existing_tags );

Like I said, collect the returned tag names into their own array: PHP Code: $existing_tags = array(); while ( $currenttags = mysql_fetch_array ( $gettags , MYSQL_ASSOC )) { $existing_tags [] = $currenttags [ 'tag_name' ]; } print_r ( $existing_tags );

Fantastic WeedPacket - thank you for your patience. I am now having another problem - I don't understand why...any ideas: This is what i'm using to get the current database of tags. For testing i've print_r the array: PHP Code: $gettags = mysql_query ( "SELECT tag_name FROM tags" ); $currenttags = mysql_fetch_row ( $gettags ); $existing...

Sorted. It seems the: PHP Code: mysql_fetch_row was messing with the query - needlessly. Thanks all.