application/models/mobile_api/Common_model.php
/* Get the shortlisted property comment total count */
Get the shortlisted property comment total count
Get the shortlisted property comment total count
public function shortlisted_property_total_comment_count($post_data){
        $userId = $post_data['userId'];
        $searchId = $post_data['searchId'];
        $shortlistedId = $post_data['shortlistedId'];
         $sql = "SELECT * FROM comments c WHERE  c.searchId= $searchId  AND c.deleteFlag != 1 AND c.shortlistedId = $shortlistedId";
        $record = $this->db->query($sql);
        if($record->num_rows()>0){
            return $record->num_rows();
        }
    }
public function shortlisted_property_total_comment_count ( $ post_data ) { $ userId = $ post_data [ 'userId' ] ; $ searchId = $ post_data [ 'searchId' ] ; $ shortlistedId = $ post_data [ 'shortlistedId' ] ; $ sql = " SELECT * FROM comments c WHERE  c.searchId=  $ searchId   AND c.deleteFlag != 1 AND c.shortlistedId =  $ shortlistedId " ; $ record = $ this -> db -> query ( $ sql ) ; if ( $ record -> num_rows ( ) > 0 ) { return $ record -> num_rows ( ) ; } }
Get the shortlisted property comment total count
Get the shortlisted property comment total count