[Resolved] script in a loop problem.

[LiquidIceB]

resolved

[Ravenous]

I think people shy away from posts with that much code. It just takes too much time to read through it to understand exactly what's going on. I know I don't want to read all that.

However, your loop seems to be coded just fine.

[LiquidIceB]

ok then i removed more then half of code...

$result_pic = mysql_query("SELECT * FROM mpn_gallery_pictures", $sqlID);
if (!$result_pic)
{
   print ("<br>Failed to open nuke gallery info");
   //exit;
}

while($row = mysql_fetch_assoc($result_pic)) 
{
	//$row = mysql_fetch_assoc($result_pic);

//reconect to nuke database...
if( !@mysql_select_db("nuke", $sqlID) )
{
	print("<br>Could not select the database 'nuke'");
	//exit;
}


$report_LOG .= "->pic " . $row['pid'] . "&nbsp;&nbsp;";


//get user info
$result_u = mysql_query("SELECT * FROM mpn_users WHERE uname LIKE '$old_username'", $sqlID);
if (! mysql_num_rows ($result_u))
{  
	//print mysql_num_rows ($result_u);
	//exit;

   $report_LOG .= "&nbsp;&nbsp;guest user&nbsp;&nbsp;";

   $old_user_id = $guest_user_id;
   $old_username = $guest_user_id_name;
  //exit;


	$report_LOG .= "&nbsp;&nbsp;Succsessfully imported photo.<br><br>";

print $report_LOG . "<br><br>";

}
}

better?

[Ravenous]

Well, not that it's that important, but you could change

if( !@mysql_select_db("nuke", $sqlID) ) 
{ 
   print("<br>Could not select the database 'nuke'"); 
   //exit; 
}

into

mysql_select_db("nuke", $sqlID) or die(mysql_error());

Again.. just a tip. Hmm.. The rest of the code..

As fot the rest, it looks fine to me. I'm sorry that I can't help you more.

[LiquidIceB]

thats ok...thanks for the tip 🙂

[LiquidIceB]

well um i just figured it otu

theres nothing wrong with the loop...its just that log variable kept concotenating info to it, and i never made it reset at begining of the loop :eek: