How to show message only once in a loop?

[rajeshkr]

hi,
I have a loop on my code, i know it will show message everytime that code will run but i want that the message only show on the final count.

for ($i = 0; $i < $post_count; $i++)
{
    $sql[] = "INSERT INTO pro_customer_album_price(customer_id, customer_name, customer_user_name, sl_no, album_name, paper, finish, price, vat, total_amt, date, time) VALUES ('$customer_id','$customer_name','$customer_user_name','".$sl_no[$i]."','".$album_name[$i]."','".$paper_used[$i]."','".$finishing[$i]."','".$price[$i]."','".$vat[$i]."','".$total_amt[$i]."','$date','$time')";

}
foreach ($sql as $query)
{

 $data = mysqli_query($con, $query);
 if(!$data)
{
echo "<br> Error".mysqli_error($con);
}
else
{
echo "Inserted!"; /// this is the message coming everytime but i want this message only show when the loop complete or in last count.
}

}

Thanks

[Weedpacket]

So have it after the loop and only show it if no errors occurred in the loop.

[rajeshkr]

Hi,
Its not like that, i did that but if the error will come during loop then the message also will come, that i don't want to do that.
thanks

[cretaceous]

for ($i = 0; $i < $post_count; $i++)
{
 ....
foreach ($sql as $query)
{

 $data = mysqli_query($con, $query);
 if(!$data)
{
$message="<br> Error".mysqli_error($con);
}
else
{
$message="Inserted!"; /// this is the message coming everytime but i want this message only show when the loop complete or in last count.
}

}
echo $message;

you might want to add "break" in case of error
or maybe put the results in an array and count the array values
$messagearray[]='what happened';

[Weedpacket]

Perhaps use a variable to record whether an error occurred or not.