connect_error) { die("Connection failed: " . $conn->connect_error); } $sql = "SELECT u_fname, u_lname FROM vts_users WHERE u_status = 1"; $result = $conn->query($sql); if ($result->num_rows > 0) { // output data of each row while($row = $result->fetch_assoc()) { echo "

". $row["u_fname"]. " " . $row["u_lname"] . "

"; } } else { echo (""); } $conn->close(); ?>