Platon Technologies
not logged in Login Registration
EnglishSlovak
open source software development celebrating 10 years of open source development! Friday, April 19, 2024
About Us
Magazine
Open Source
CVS
Services
Index  »  Projects  »  phpMyEdit  »  Forum  »  Joining 3 Related Tables in phpmyedit
Main | View Bugs | Report Bug | Summary | Forum | Documentation | Download

phpMyEdit General     Joining 3 Related Tables in phpmyedit
Post new topic   Reply to topic    
 
fraka     Joined: 16 Jul 2015   Posts: 1  
Post Posted: 2015-07-16 11:11
Back to top  Reply with quote     

Help plz: how to join three related tables with phpmyedit?

Example
Table1(empl): employee_id, employee_name

Table2(empl_dept): row_id, employee_id, dept_id

Table3(Dept): dept_id, dept_name

I want to join them in phpmyedit to be able to get the dept to which an employee belongs.

 
doug     Joined: 10 Feb 2003   Posts: 1013   Location: Denver, Colorado (USA)
Post Posted: 2015-07-16 17:23
Back to top  Reply with quote     

Documentation does not indicate the possibility of joining more than two tables.
http://opensource.platon.org/projects/doc.php/phpMyEdit/html/configuration.input-restrictions.html#AEN993

You might want to use phpmyadmin to create a view, then use phpmyedit to read the view.

Otherwise use the forum search feature to see if anyone posted code for: join three tables, or join 3 tables

 
Post new topic   Reply to topic    

Main | View Bugs | Report Bug | Summary | Forum | Documentation | Download
Copyright © 2002-2006 Platon Group
Site powered by Metafox CMS 		Go to Top · Feedback form · Application form
Report bug on PLATON.SK website · Terms of use · Privacy policy