<?php

//get counselor data
global $wpdb;
$PSY_COUNSELORS = $wpdb->prefix . PSY_COUNSELORS;

$getCounselors = $wpdb->get_results("SELECT c.counselor_id, c.counselor_name, c.counselor_title, c.url_slug, c.profile_image, c.short_desc from $PSY_COUNSELORS as c where c.status='1' order by c.display_order");
?>
<!-- COUNSELORS SECTION -->

<section class="counselors-page-section">
    <div class="container">

        <div class="row">
            <div class="col-md-12 col-sm-12 col-xs-12">
                <h1 class="counselors-page-head">OUR COUNSELORS</h1>
            </div>

            <?php
            foreach ($getCounselors as $co) {

            ?>
                <div class="col-md-6 col-sm-6 col-xs-12">
                    <div class="counselors-page-box">
                        <div class="counselors-page-img">
                            <img src="/counselor/profile-image/<?php echo $co->profile_image ?>" alt="<?php echo $co->counselor_name ?>">
                            <h4><?php echo $co->counselor_name ?></h4>
                            <p><?php echo $co->counselor_title ?></p>
                            <button><a href="/counselor-profile/<?php echo $co->url_slug ?>/">View Profile</a></button>
                        </div>
                        <div class="counselors-page-div">
                            <?php echo $co->short_desc ?>
                        </div>
                    </div>
                </div>
            <?php
            }
            ?>
        </div>
    </div>
</section>

<!-- END COUNSELORS SECTION -->