Platon Technologies
not logged in Login Registration
EnglishSlovak
open source software development celebrating 10 years of open source development! Sunday, October 18, 2026
About Us
O nás
Magazine
Magazín
Open Source
Otvorený softvér
CVS
CVS
Services
Služby
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 · Odkazový formulár · Application form · Prihláška
Report bug on PLATON.SK website · Upozorniť na chybu na PLATON.SK webstránke · Terms of use · Podmienky použitia · Privacy policy · Ochrana osobných údajov