Display loop output one line at a time

[Inpresif]

I have this while loop I use for emailing clients in the database:

while($db = mysql_fetch_array($resulttemps))
{
                                    $to = $db['email'];
                                    $ln = $db['last_name'];
                                    price($db['prod_id']);
                                    $msg .= $msgform;
                                    mail("$to",$subject,stripslashes($msg),"From: $mymail\n");
                                    echo "Mail to $to with subject: $subject -> <b>sent</b> !<br>";
                                }

The output of this loop is only visable when all the clients are emailed. Is there a way to display each output line by line, so I can see the process of the emailing?

[cosminb]

add a flush() after each echo

.... more info

[Inpresif]

Originally posted by cosminb
add a flush() after each echo


.... more info

great, thanks.

[bubblenut]

Unless you're doin outputbuffering then it will do. However, the lag may not be in the mailing but in the actual query. When you perform myqsl_query the query must complete before the function can return. This is where most bottlenecks occur
HTH
Bubble

[Inpresif]

Originally posted by bubblenut
Unless you're doin outputbuffering then it will do. However, the lag may not be in the mailing but in the actual query. When you perform myqsl_query the query must complete before the function can return. This is where most bottlenecks occur
HTH
Bubble

My query is rather simple, so I doubt it causes much delay ...

            if ($wie == "transfer"){
            $ookwaar = "WHERE ((datum < '$vorigeweek') AND (id LIKE 'man_%'))";
            }else{
            $ookwaar = "WHERE (datum < '$vorigeweek')";
            }

$resulttemps = mysql_query("SELECT email,last_name,datum,prod_id FROM $mysql_tempdata_table $ookwaar GROUP BY email");

At this point less than 250 clients who need these mails, but it grows steadily.