$contactStatus); $res = db_query_val($query, $values); foreach ($res as $row){ echo ""; echo ""; echo ""; echo ""; echo ""; $query = "SELECT dateAdded FROM communication WHERE customerID=:customerID ORDER BY dateAdded DESC LIMIT 1"; $values = array(":customerID" => $row['id']); $res_dateAdded = db_query_val($query, $values); echo ""; echo ""; echo ""; echo ""; echo ""; } ?>

ID	Company Name	Sales Person	Contact Status	Last Contact Date	email	phone
ID	Company Name	Sales Person	Contact Status	Last Contact Date	email	phone
ID	Company Name	Sales Person	Contact Status	Last Contact Date	email	phone
".$row['id']."	".$row['companyName']."	".$row['sales_first_name']." ".$row['sales_last_name']."	".$row['contactStatus']."	".$res_dateAdded[0][0]."	".$row['email']."	".$row['phone']."	View Details