SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    Patience... bronze trophy solidcodes's Avatar
    Join Date
    Jul 2006
    Location
    Philippines
    Posts
    911
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Missing Relation View in PHPMyAdmin?

    Hi guys,

    I have 4 tables.

    1. Pathways
    2. Classes
    3. Parts
    4. Lessons

    pathid(FK) from Pathways table exist on Classes table.
    when I click 'Classes' table and structure the Relation view is shown.

    classid(FK) from Classes table exist on Parts table.
    Now when I click 'Parts' table and structure the Relation view is now shown.

    Why is this?
    How to display the Relation view?

    Thanks in advance.
    I Love coding...
    Don't click this link.

  2. #2
    Patience... bronze trophy solidcodes's Avatar
    Join Date
    Jul 2006
    Location
    Philippines
    Posts
    911
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)
    Why I can't edit this thread?
    The first post has wrong spelling in it.

    Anyway here is the corrected paragraph,

    Code:
    classid(FK) from Classes table exist on Parts table.
    Now when I click 'Parts' table and structure the Relation view is not shown.
    How to fix this to display the "Relation view"?
    I Love coding...
    Don't click this link.

  3. #3
    Patience... bronze trophy solidcodes's Avatar
    Join Date
    Jul 2006
    Location
    Philippines
    Posts
    911
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)
    I'm so stupid I did not noticed the Parts table is not set to InnoDB.
    Anyway problem solved now.
    I Love coding...
    Don't click this link.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •