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