Welcome Guest, Not a member yet? Register   Sign In
CodeIgniter Forums Using CodeIgniter General Help How to structure effectively news and category relationship ?
How to structure effectively news and category relationship ?
  • Offline paju89
    Junior Member
  • **
  • Posts: 20
    Threads: 6
    Joined: Dec 2014
    Reputation: 0
#1
12-09-2014, 08:21 AM

i have two tables in database

CATEGORY table below if parent id is set to 0 is main category if it is set to any its subcategory
cat_id | name | parent_id
---------------------------------------
1 | Electronics | 0
2 | Computer | 1
3 | Computer | 1

NEWS table below

id | news_name | news_text | cat_id
---------------------------------------


i wonder how to make them related each others via common id ? Any ideas
Reply


Messages In This Thread
How to structure effectively news and category relationship ? - by paju89 - 12-09-2014, 08:21 AM



Theme © iAndrew 2016 - Forum software by © MyBB