I hope this is the right place for this thread.
I was wondering if it's possible to set up relationships for my database using phpMyAdmin on this server. If so, please direct me because I have been looking for it and cannot find it.
Thanks a lot
I hope this is the right place for this thread.
I was wondering if it's possible to set up relationships for my database using phpMyAdmin on this server. If so, please direct me because I have been looking for it and cannot find it.
Thanks a lot
This forum is ostensibly for help with 3rd party apps you've installed, rather than for the apps X10 provides for site administration. On the other hand, phpMyAdmin is an app created neither by you nor X10, so is thus "3rd party". The free hosting forum might be more appropriate (a forum admin can move the thread to an appropriate forum, if necessary).
As for your problem, if you mean "relationship" in a relational model theoretical way (which is called a "table" in common parlance), you can create them in different ways, depending on whether the database has no tables or has tables (a web search may turn up better tutorials; at some point, I may add one to X10's wiki, or to phpMyAdmin's). Databases and users must be created from cPanel. If by "relationship" you mean "foreign key", you would use the "Relation View" link on the "Structure" tab for the table. However, it looks as though the relation view feature isn't enabled on X10. If you want it, request it in the Feedback and Suggestions forums (include a poll to get others' support). You can always create foreign keys by running SQL queries from phpMyAdmin. Both tables must be InnoDB, and the column(s) must be indexed on the foreign table.
Last edited by misson; 01-20-2011 at 04:54 PM.
Be sure to read all pages linked in this post; they have further information that should prove useful. When asking for help, make sure you follow Eric Raymond's and Jon Skeet's guidelines for prompt, accurate responses. Please answer any questions I ask; they're not rhetorical (probably). Any posted code is intended as illustrative example, rather than a solution to your problem to be copied without alteration. Study it to learn how to write your own solution.Misson, not Mission.
█ BCV | Community Support Representative
█ x10Hosting - Giving Away Hosting Since 2004
█ Premium Hosting | VPS Services