logic issues....

[agoni]

gah! my mind is just a stupid pile of crap today. i have no idea how to solve my problem. i've got this dummy script set up (just for test like) which accepts a string via post like so "item 1, item 2, a dog, hello" you see? no i have a database set up with a table called tags. now any one of these string could already exist in the database, so i need to check if they do or not right?

i'm using this (from my pitiful knowledge of php) at the moment, and the results are all wrong. it's just not working.

<?
$theTags = $_POST['tags'];
/*$result = mysql_query("SELECT tag_NAME FROM tags");
while ($row = mysql_fetch_array($result)) {
extract ($row);
print ("$tag_NAME<br>");
}*/
$tagArr = array();
$tagArr = split (", ", $theTags);
for ($i=0; $i<count($tagArr); $i++) {
	print ("$tagArr[$i]<br>");
	$test = mysql_query("SELECT tag_NAME FROM tags");
	while ($row = mysql_fetch_array($test)) {
		extract($row);
		if ($tag_NAME == $tagArr[$i]) {
			print ("$tagArr[$i]  is in DB<br>");
		} else {
			print ("$tagArr[$i]  is not in DB<br>");
		}
	}
}
?>

go here > http://www.void-inc.net/control/voidPhoto/addPhotosWizard/step2.php for an example.

please help. is there an easier way to accomplish this? is my logic all wrong? does it require recursion? (omg help!)

[Installer]

Something like this should work:

$tagArr = array(); 
$tagArr = split (", ", $theTags); 
$test = mysql_query("SELECT tag_NAME FROM tags"); 
while ($row = mysql_fetch_array($test)) {
    extract($row);
    $db_tags[] = $tag_NAME;
}
for ($i = 0; $i < count($tagArr); $i++) { 
    print ("$tagArr[$i]<br>"); 
    if (in_array($tagArr[$i], $db_tags) {     

        print ("$tagArr[$i]  is in DB<br>"); 
    } else { 
        print ("$tagArr[$i]  is not in DB<br>"); 
    } 
}

I'd use a foreach, though:

foreach ($tagArr as $value) { 
    print ("$value<br>"); 
    if (in_array($value, $db_tags) {     

        print ("$value is in DB<br>"); 
    } else { 
        print ("$value is not in DB<br>"); 
    } 
}

And you can do without the "extract()":

while ($row = mysql_fetch_array($test)) {
    $db_tags[] = $row['tag_NAME'];
}

Edit: You could combine the two loops, too, although the posted tags might show up out of order:

while ($row = mysql_fetch_array($test)) {
    extract($row);
    if (in_array($tag_NAME, $tagArr)) {
        print ("$tag_NAME  is in DB<br>"); 
    } else { 
        print ("$tag_NAME  is not in DB<br>"); 
    } 
}

[agoni]

thank you so so so much, this worked amazingly well. 😃