$rowcount = mysqli_num_rows($result2);
if ($rowcount > 0) {
$executive[$row['received']] = $row2['name'];
$received_name[$row['received']] = $executive[$row['received']];
} else {
$executive[$row['received']] = "";
$received_name[$row['received']] = $row['received'];
}
}
$table .= "<td>" . $executive[$row['received']] . "</td>";
for ($a = 0; $a < count($select_list); $a++) {
if ($select_list[$a] == 'account_type') {
$table .= "<td>" . ucwords(str_replace("_", " ", $row['account_type'])) . "</td>";
} else {
if ($select_list[$a] == 'date_sent') {
$table .= "<td>" . convert_to_dateTime($row['date_sent']) . "</td>";
} else {
if ($select_list[$a] == 'date_created') {
$date = "";
if ($row['date_created'] != '') {
$date = date("F j, Y", strtotime($row['date_created']));
}
$table .= "<td style='text-align:center '>" . $date . "</td>";
} else {
$table .= "<td style='text-align:center'>" . $row[$select_list[$a]] . "</td>";
}
}
}
}
$table .= "<td>";
if (!empty($access['Hide'])) {
$result = $conn->query($select);
if ($result->num_rows > 0) {
echo "<td style='vertical-align:top'>";
echo "<h2>SMS List</h2>";
echo "<table style='border-collapse:collapse'>";
echo "<tbody style='border:1px solid black;display:block;height:400px;overflow:auto;min-width:300px'>";
$a = 0;
while ($row = $result->fetch_assoc()) {
// echo "<tr><th>".$row['received']."</th></tr>";
// echo "<tr><th style='width:60px;padding-left:10px;padding-top:8px;padding-bottom:10px;text-align:left'>Sender</th> <td style='padding-left:10px;padding-top:8px;padding-bottom:10px;text-align:left'>".$row['received']."</th></tr>";
echo "<tr id='sms_row" . $a . "' style='vertical-align: middle;display:block' name='sms_row" . $a . "'>";
echo "<td style='width:60px;padding-left:10px;padding-top:8px;padding-bottom:10px;text-align:right;vertical-align: middle;'>\n <input type='checkbox' id='sms_id{$a}' name='sms_id[] ' value='" . $row['sms_id'] . "' style='text-align:right;width:50px;height:30px' ></td>";
echo "<td style='padding-left:5px;border:1px solid black;min-width:250px;min-height:190px;vertical-align: middle;'>" . $row['sms'] . "</td>";
echo "</tr>";
echo "<tr id='sms_row" . $a . "' name='sms_row" . $a . "'>";
echo "<td colspan=2 style='padding-left:10px;text-align:left'>" . convert_to_dateTime($row['date_sent']);
echo "<input type='button' style='border:none;background-color:transparent;margin:10px;textdecoration:underliner;' onclick='hide_this({$a})' value='Hide'>";
echo "</td>";
echo "</tr>";
$a++;
}
// echo "<input type='hidden' id='num' name='num' value='$a'>";
echo "</tbody>";
echo "<tr>";
echo "<td colspan=2 style='text-align:center'><input type='hidden' id='num' name='num' value='{$a}'>\n <input style='width:100px;padding:5px;height:20px' type='submit' name='match_submit' value='Match' ></td>";
echo "</tr>";
echo "</table>";
echo "</td>";
} else {
echo "<td><h2>No Data Found</h2></td>";
}