Platon Technologies
not logged in Login Registration
EnglishSlovak
open source software development celebrating 10 years of open source development! Friday, March 29, 2024
About Us
Magazine
Open Source
CVS
Services
Index  »  Projects  »  phpMyEdit  »  Forum  »  Query multiple tables using PhpMyedit

phpMyEdit General     Query multiple tables using PhpMyedit
Post new topic   Reply to topic    
 
johnygmalayil     Joined: 19 Aug 2015   Posts: 5  
Post Posted: 2016-03-16 16:52
Back to top  Reply with quote     

How do I write a select query in phpmyedit to query multiple tables.

I know to query a single table I just need to write

$opts ['tb'] = 'table_one';

Is there some option to query in more tables ?

 
doug     Joined: 10 Feb 2003   Posts: 1013   Location: Denver, Colorado (USA)
Post Posted: 2016-03-16 18:44
Back to top  Reply with quote     

http://opensource.platon.org/projects/doc.php/phpMyEdit/html/configuration.input-restrictions.html#AEN971

Table lookup is simple. Joining is more complex. See documentation.

 
johnygmalayil     Joined: 19 Aug 2015   Posts: 5  
Post Posted: 2016-03-17 01:39
Back to top  Reply with quote     

I was able to join the two tables. But I want to print a field
from the second table. Hows it done ?

 
yousuf     Joined: 16 Sep 2021   Posts: 92  
Post Posted: 2021-11-14 11:05
Back to top  Reply with quote     

Your current article normally have got much of really up to date info. Where do you come up with this? Just stating you are very imaginative. Thanks again buy real instagram followers

 
ArtAlberto     Joined: 27 Feb 2022   Posts: 8  
Post Posted: 2022-12-31 16:11
Back to top  Reply with quote     

If you want to query multiple tables at once, you can do this by using a join. If you want to find the sum of sales for all products, you use 먹튀앱 in an UPDATE statement, because this would return anything at all. The easiest way to get around this problem is to use a subquery or a correlated subquery.

 
Post new topic   Reply to topic    

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