niche Posted December 21, 2011 Share Posted December 21, 2011 Is their a way to view two joined files in phpmyadmin, or is there plugin available for this, or will I need to create my own interface? Link to comment Share on other sites More sharing options...
justsomeguy Posted December 21, 2011 Share Posted December 21, 2011 What are joined files? Link to comment Share on other sites More sharing options...
niche Posted December 21, 2011 Author Share Posted December 21, 2011 File that shares a common key. Where one of the files the key would be a primary key. Link to comment Share on other sites More sharing options...
justsomeguy Posted December 21, 2011 Share Posted December 21, 2011 Are these text files? You don't mean regular database tables, right? How are you querying the data? Are you using MySQL? Link to comment Share on other sites More sharing options...
niche Posted December 21, 2011 Author Share Posted December 21, 2011 Excuse me. mysql tables. Link to comment Share on other sites More sharing options...
justsomeguy Posted December 21, 2011 Share Posted December 21, 2011 Ok, so you're asking how to view the results of a query that uses a join? You would use the SQL tab to write your query there and tell it which tables you want to join and what you want to join them on. Link to comment Share on other sites More sharing options...
niche Posted December 21, 2011 Author Share Posted December 21, 2011 Thanks. Where do I put the php so I can echo the cols that I need to see? Link to comment Share on other sites More sharing options...
niche Posted December 21, 2011 Author Share Posted December 21, 2011 I just phpmyadmin says I just successfully created a view. Where was it saved? How do I view the view? Link to comment Share on other sites More sharing options...
niche Posted December 21, 2011 Author Share Posted December 21, 2011 It showed up in my table list. Makes sense. So, I seems I should use the "create view" to insert my sql and specify the columns I need to display. Thanks justsomeguy. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.