Okay, I was the one that asked the crazy question about the weird join, but I got that figured out. Now I have a problem.
while( ($login, $existingemail, $areacode, $prefix, $rest) = $sth->fetchrow_array ()) { print "$login,$existingemail,$areacode-$prefix-$rest\n"; } That code is inside my foreach statement, but existingemail is an optional field. If there is no email address given, I would like to print out "NO EMAIL PROVIDED". How do I do this within my while loop. When this report is run, it is piped to a csv file so that it can easily be imported into Excel. Thanks in advance for the help. Aaron Shurts -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]