certain member type: --> <tr><th colspan="2">Add to Housing Pool</th></tr> <tr> <td><select id="pool_type"> <option value="">--Pool Member Type--</option> <?php $get_types_sqlsafe = "SELECT * FROM Pool_Member_Types;"; include "../include/dbconnopen.php"; $all_types = mysqli_query($cnnSWOP, $get_types_sqlsafe); while ($type = mysqli_fetch_row($all_types)) { ?> <option value="<?php echo $type[0]; ?> " <?php echo $type[1] == $participant->get_type() ? 'selected="selected"' : null; ?> ><?php echo $type[1]; ?> </option> <?php } include "../include/dbconnclose.php"; ?> </select> </td> <td> <?php if ($USER->site_access_level($SWOP_id) <= $DataEntryAccess) { ?>
echo $parti['Gender'] == 'm' ? 'selected="selected"' : null; ?> >Male</option> <option value="f" <?php echo $parti['Gender'] == 'f' ? 'selected="selected"' : null; ?> >Female</option> </select> </td> </tr> <tr> <td><strong>Pool Member Type: </strong></td> <td> <span class="basic_info_show"><?php echo $participant->get_type(); ?> </span> <select class="basic_info_pool_edit" id="type_pool_edit"/> <option value="">-------</option> <?php $get_types_sqlsafe = "SELECT * FROM Pool_Member_Types;"; include "../include/dbconnopen.php"; $all_types = mysqli_query($cnnSWOP, $get_types_sqlsafe); while ($type = mysqli_fetch_row($all_types)) { ?> <option value="<?php echo $type[0]; ?> " <?php echo $type[0] == $participant->get_type_id() ? 'selected="selected"' : null;