Guest User

Untitled

a guest
May 21st, 2018
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.82 KB | None | 0 0
  1. ## Background to Problem
  2.  
  3. I have the below database layout, but I want to be able to have a 'menu'
  4. so that if you are viewing 'Cantelever' below, you have a clickable menu
  5. that can take you to the other parent levels.
  6.  
  7. For example: Shimano -> Brakes -> Cantelever
  8. where Shimano links to /category/id/1
  9. Brakes links to /category/id/2
  10. and Cantelever (which is the current level) may or may not link
  11. to itself (I haven't decided).
  12.  
  13.  
  14. ## Current Database Layout (Object Levels)
  15.  
  16. Object Level ID | Object Level Name | Object Parent ID | Object Menu Level
  17.  
  18. 1 Shimano 0 1
  19.  
  20. 2 Brakes 1 2
  21.  
  22. 3 Cantelever 2 3
  23.  
  24. 4 V-Brakes 2 3
Add Comment
Please, Sign In to add comment