Platon Technologies
not logged in Login Registration
EnglishSlovak
open source software development celebrating 10 years of open source development! Wednesday, November 11, 2026
About Us
Magazine
Open Source
CVS
Services
Index  »  Projects  »  phpMyEdit  »  Forum  »  Joining tables with dropdown Field

phpMyEdit General     Joining tables with dropdown Field
Post new topic   Reply to topic    
 
simsalabim     Joined: 22 Jun 2007   Posts: 1  
Post Posted: 2007-06-22 16:28
Back to top  Reply with quote     

Hey,

I'm trying to join two tables now for hours but it seems I'm just to stupid ...

I found a lot of threads to this question here on the board, but I do not get it to run.


Table1: [fahrer]
Columns: [id], [name], [nickname]

Table2: [score]
Columns: [id], [fahrer_id], [race], [timescore],

The columns [fahrer].[id] and [score].[fahrer_id] should be joined.

When displaying I'd like to have the [fahrer_id] displayed.
When adding/editing I'd like to have the [name] as a dropdown field to set the [fahrer_id].


Could anybody give me the correct syntax ?

Is there a wizard for joining tables, like there is for a single table (phpMyEditSetup.php) ?


Thanks in advance !

 
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