=:startDate AND dateAdded <=:endDate"; $values = array(":userID" => $userID, ":startDate" => $startDate, ":endDate" => $endDate); $messages = db_query_val($query, $values); foreach ($messages as $message){ ?>

Customer	Date	Message Type	Message
Customer	Date	Message Type	Message

$userID); $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