<?php
                global $wpdb;
    $wp_user_search = $wpdb->get_results("SELECT ID, display_name FROM $wpdb->users ORDER BY ID");
    //    $wp_user_search = $wpdb->get_results("SELECT user_id, meta_value FROM $wpdb->usermeta WHERE $wpdb->usermeta.meta_key = 'last_name' ORDER BY $wpdb->usermeta.meta_value ASC");



    foreach ( $wp_user_search as $userid ) {

        $user_id = (int) $userid->ID;
//$user_id = (int) $userid->user_id;
        $user_info = get_userdata($user_id);

        $first_name = stripslashes($user_info-> user_firstname);
        $last_name = stripslashes($userid-> user_lastname);

        $family_surname = stripslashes($user_info-> user_lastname);
        $spousename = get_user_meta ($user_id,"spouse_name",true);
        $phone = get_user_meta ($user_id,"phone",true);
        $address_listed = get_user_meta ($user_id,"address_listed",true);
        $address_street = get_user_meta ($user_id,"address_street",true);
        $address_city = get_user_meta ($user_id,"address_city",true);
        $address_prov = get_user_meta ($user_id,"address_prov",true);
        $address_postal = get_user_meta ($user_id,"address_postal",true);

        $area_I_live = get_user_meta ($user_id,"area_I_live",true);

        $our_children = get_user_meta ($user_id,"our_children");

        $statement_of_faith = get_user_meta ($user_id,"statement_of_faith",true);

        $email = $user_info-> user_email;

        if($user_id <> 2) {
            echo '<tr>';
            if($statement_of_faith == 'Yes'){
            echo '<td class="faith" rowspan="3">&#8224;</td>';
            } else {
             echo '<td rowspan="3">&nbsp;</td>';
            }

            echo '<td>'. $family_surname . '</td>';

            echo'<td>'.  $first_name .'</td>';

            if($spousename <> ''){
                echo '<td>'. $spousename . '</td>';
            }else{
                echo '<td>&nbsp;</td>';
            }

            echo '<td>'. $phone . '</td>';
            echo '<td>'. $email . '</td>';

            echo '</tr>';
            if($address_listed == 'Yes'){
            echo '<tr><td>'.$address_street.'<br />'.$address_city.', '.$address_prov.'</td><td><br/>'.$address_postal.'</td><td colspan="3">'.$area_I_live.'</td></tr>';
            }

            //foreach ( $our_children as $children ) {
            echo '<tr><td>'. $our_children-> Name .'</td><<td>'. $our_children-> Age .'</td></tr>';
            //}
        }
    }