ThunderAI Posted June 21, 2008 Share Posted June 21, 2008 Does anyone have a good module or 3rd party code that they use to display rows of data across many different tables? I am looking into redesigning the code i use for the datagrid and i was curious what was out there. Quote Link to comment Share on other sites More sharing options...
DarkWater Posted June 21, 2008 Share Posted June 21, 2008 Wait, graphing or just displaying data? Also, what do you mean "across many different tables"? Quote Link to comment Share on other sites More sharing options...
ThunderAI Posted June 21, 2008 Author Share Posted June 21, 2008 Wait, graphing or just displaying data? Also, what do you mean "across many different tables"? Just displaying table data in row format. By many different tables i mean it can support tables that have primary and child key fields, like in InnoDB tables. And the code can be reused for a different table by chaning only a few lines of code. Quote Link to comment Share on other sites More sharing options...
Barand Posted June 21, 2008 Share Posted June 21, 2008 there's one in my sig Quote Link to comment Share on other sites More sharing options...
ThunderAI Posted June 22, 2008 Author Share Posted June 22, 2008 there's one in my sig That looks good, what about the following situation tbl_users > user_id > user_name tbl_activity > activity_id > activity_user_id SELECT * FROM tbl_activity INNER JOIN tbl_users ON tbl_users.user_id = tbl_activity.activity_user_id Can your table do the relation of those two tables automatically or how do i pass what fields I want displayed? Quote Link to comment Share on other sites More sharing options...
Barand Posted June 22, 2008 Share Posted June 22, 2008 Can your table do the relation of those two tables automatically ? It leaves that to MySQL. Just pass it the query how do i pass what fields I want displayed? In the SELECT clause. You can also specify hidden columns Quote Link to comment 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.