[gengar003]

Okay, using that code, I've modified it to run through a table, called "tacemon" until there's nothing left, and each time, execute a bit of code:

PHP Code:

$mypkmndat = "";
$tacemonqing = $DB_site->query("SELECT name,catchname FROM tacemonquery ORDER BY name"); 
while($loopy = $DB_site->fetch_array($tacemonqing)) 
{ 
$th_rite_name = $loopy[name];
$th_rong_name = $loopy[catchname];


if ($bbuserinfo[$catchname]=="1") { 

$mypkmndat .= "<img src=\"http://pgsforum.com/vb/images/tac/tac/caught/";
$mypkmndat .= $th_rite_name;
$mypkmndat .= ".gif\">"; 
} else  { 
}

 
} 

$bbuserinfo['tacemon'] = $mypkmndat; 

$DB_site->query("UPDATE user SET tacemon = '".$bbuserinfo[tacemon]."' WHERE userid='".$bbuserinfo['userid']."' LIMIT 1"); 


Anyway, When I hard-code the code in the while loop for each entry in the DB table, it works, but not when I use the loop. However, when I place an "echo $loopy[name];" in the loop, but not in the if statement, It prints the names on the page, so I know the loop works.


This probably has to do with global/local variables, but I tired declaring $mypkmndat as global (Which I assume is the problem, since it's the variable that I want to use outside of the loop) but that didn't help.

Anyway, anyone know what I've done wrong?

EDIT: *sigh* after all that typing describing my problem, I found the answer going over my post. $catchname should've been $th_rong_name. I changed it, an' it works.

:dead: :nervous: :cry:

Now the real test will be how it handles me adding a new row...