query($query); // Generate HTML of state options list if($result->num_rows > 0){ echo 'Select Source of Income'; while($row = $result->fetch_assoc()){ echo ''.ucwords($row['c3']).''; } }else{ echo 'Income not available'; } ?>