This should do the trick:
code:
$query = "SELECT U_Username,U_Phonehome,U_Phonework,U_Phonecell,U_Winch,U_Coverage,U_Calltime
FROM {$config['tbprefix']}Users
WHERE U_Phonehome != '' OR U_Phonework != '' OR U_Phonecell != ''
";
$sth = $dbh -> do_query($query);
while ( list($Username,$HomePhone,$WorkPhone,$CellPhone,$Winch,$Coverage,$Calltime) = $dbh -> fetch_array($sth)) {
echo <<<UBBTPRINT
$Username
$HomePhone
$WorkPhone
$CellPhone
$Winch
$Coverage
$Calltime
<br />
UBBTPRINT;
}
$dbh -> finish_sth($sth);
Or at least give you an idea what to do next.
