File manager - Edit - /home/autoph/public_html/voc/home/display_group_members.php
Back
<?php include 'core/init.php'; error_reporting(0); //if submit/ save to databasevar ` if(isset($_POST['done'])){ $getMembers = mysql_query("SELECT * FROM `vts_users` WHERE `u_position` LIKE '%$mPosition%' AND `u_status`= 1 AND `sales_group`='' ORDER BY `u_lname` ASC"); echo "<table style='width:100%'>"; echo "<thead>"; echo "<th>ID</th>"; echo "<th>Name of Members</th>"; echo "<th>Group Head</th>"; echo "<th>Members</th>"; echo "</thead>"; while($row=mysql_fetch_array($getMembers)){ $gID= $row['u_id']; $gFname = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$gID'"),0); $gLname = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$gID'"),0); $getMember = mysql_result(mysql_query("SELECT COUNT('u_id') FROM `vts_users` WHERE `sales_group`='$gID'"),0); ?><tr ondblclick="popUpShowDisplayAddMembers()"><?php echo "<td>".$row['u_id']."</td>"; echo "<td style='text-align:center'>".$row['group_name']."</td>"; echo "<td>".$gLname. ", ".$gFname."</td>"; echo "<td style='text-align:center'>".number_format($getMember,0,'.',',')."</td>"; echo "</tr>"; } echo "</table>"; } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings