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
    936
    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.
    Quality codes are optimized and tested...
    Click here for inspiration..

  2. #2
    Patience... bronze trophy solidcodes's Avatar
    Join Date
    Jul 2006
    Location
    Philippines
    Posts
    936
    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"?
    Quality codes are optimized and tested...
    Click here for inspiration..

  3. #3
    Patience... bronze trophy solidcodes's Avatar
    Join Date
    Jul 2006
    Location
    Philippines
    Posts
    936
    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.
    Quality codes are optimized and tested...
    Click here for inspiration..


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
  •