(07-09-2019, 07:12 PM)acebay Wrote: Hi all, I have a question

Let say we have this 2 tables in our database

first table : category_lists

category_lists_id   |    category
============================
1                         |    Accident Management
2                         |    Aluminium
3                         |    Brass
4                        |    Car Services
5                         |    Car Towing
6                        |    Car Wreckers
7                         |    Cash For Cars


second table: data_category


id                        |   list_data_id        |       category_lists_id 
===================================
1                         |    3                     |          5
2                         |    3                     |          6
3                         |    3                     |          7  
4                        |    2                      |          8
5                         |    4                     |          5
6                        |    1                      |          6
7                         |    1                     |          7


so if list_data_id is equal to 1 meaning that it has 2 data if you look at data_category table which is 6 and 7

Now what I want is to query from category_list table so that 6 and 7 will echo Car Wreckers and Cash For Cars.

This is what my code looks like:

below is my controller

PHP Code:

public function index($listing_name)
    {

        $this->load->view('layouts/head_layout_seo');
        $this->load->view('layouts/head_layout');

        $data['main_view'] = 'listings/main_view';
        $data['listing_data'] = $this->Listing_model->get_detail_listing($listing_name);

        $list_id = $data['listing_data']->list_data_id; // this is what I get list_data_id is equal to 1

        $data['category_ads'] = $this->Ads_model->get_ads($list_id); // this is what you need to look

        $this->load->view('layouts/main', $data);

        $this->load->view('layouts/footer_layout');

    } 


below is my model

PHP Code:

    public function get_ads($list_id)
    {
        $this->db->where('list_data_id', $list_id);
        $query = $this->db->get('data_category');
        $query = $query->result();
        //return $query;

        if (count($query) > 0) {    
            for ($i=0; $i < count($query); $i++) { 
                foreach ($query as $value) {
                    $this->db->where('category_lists_id', $value->category_lists_id);
                    $querys = $this->db->get('category_lists');
                    //print_r($query);
                    return $querys->result();
                }
            }    
        }
    } 


below is my view:

Code:

<?php foreach ($category_ads as $value) { ?>
    <p><a href=""><?php echo $value->categories; ?></a></p>
<?php } ?>

with the code above I get only 1 data which is Car Wreckers as you can see from the table it suppose to show 2 data Car Wreckers and Cash For Cars

Can anyone help me with this?

Thank You