blue-genie Posted April 19, 2010 Share Posted April 19, 2010 Hi all. I'm using xammpp version 1.6.3 with mysql 5.0.45 and php 5.2.3 i've followed this tutorial to try and set up relations etc. http://www.learnphp.org/tutorials/Setting-Up-Foreign-Keys-Using-PhpMyAdmin-63466.html although I've followed this step by step, I can't get that relation view to show up. can anyone provide some pointers. thanks. blu. Quote Link to comment https://forums.phpfreaks.com/topic/198984-phpmyadmin-help/ Share on other sites More sharing options...
JustLikeIcarus Posted April 19, 2010 Share Posted April 19, 2010 You did define the tables as InnoDB correct? Quote Link to comment https://forums.phpfreaks.com/topic/198984-phpmyadmin-help/#findComment-1044611 Share on other sites More sharing options...
blue-genie Posted April 20, 2010 Author Share Posted April 20, 2010 Hi no. My type is MyISAM. if i check storage engine, have the following options available memory, blackhole, archive, federated, mrg_myisam. I always leave these as default values. Quote Link to comment https://forums.phpfreaks.com/topic/198984-phpmyadmin-help/#findComment-1045046 Share on other sites More sharing options...
JustLikeIcarus Posted April 20, 2010 Share Posted April 20, 2010 InnoDB is the engine which has to be used for a relational database. This is why you aren't getting those options. Quote Link to comment https://forums.phpfreaks.com/topic/198984-phpmyadmin-help/#findComment-1045100 Share on other sites More sharing options...
blue-genie Posted April 21, 2010 Author Share Posted April 21, 2010 i have tried googling but i cant' find how to change my table type. can you advise? Quote Link to comment https://forums.phpfreaks.com/topic/198984-phpmyadmin-help/#findComment-1045657 Share on other sites More sharing options...
JustLikeIcarus Posted April 21, 2010 Share Posted April 21, 2010 Can you post the contents of you my.cnd config file? Quote Link to comment https://forums.phpfreaks.com/topic/198984-phpmyadmin-help/#findComment-1045904 Share on other sites More sharing options...
blue-genie Posted April 29, 2010 Author Share Posted April 29, 2010 hi sorry i took so long to get back to you. this site is so busy I keep losing my posts. i searched through my xampp folder and I can't find a my.cnd file. Quote Link to comment https://forums.phpfreaks.com/topic/198984-phpmyadmin-help/#findComment-1050347 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.