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  »  Displaying Information from 2 tables in Select Drop down

phpMyEdit General     Displaying Information from 2 tables in Select Drop down
Post new topic   Reply to topic    
 
aslan     Joined: 22 May 2004   Posts: 5  
Post Posted: 2004-07-12 23:25
Back to top  Reply with quote     

I have 3 tables, on that is being populated.

The other two are related through and id so the tables are similar to this

Table 1 (table to be populated)
ID
Name
Type_ID

Table 2 (Where Type_ID is pulled from)
Type_ID
Type_Name
Cat_ID

Table 3 (Where Cat ID from tbl 2 is pulled)
Cat_ID
Cat_Name

For table one I want to display the Type_Name & Cat_Name in a pulldown to populate Type_ID in #1.

Reason some Categories have Types that have the same name, but the data in those types remains different.

Thanks,
A

 
pakman     Joined: 09 Jul 2004   Posts: 5  
Post Posted: 2004-07-13 15:53
Back to top  Reply with quote     

i've got similar problem.

I've tried join, [description] etc and it doesn't work.
I only want to build the f*k*ng description from the fields of other tables. I don't know why in the description array is impossible to make relation to another table. If 'description' wasn't a query to a table, maybe with simple coding i can made it making another query to db and writing it manually. But not, the 'description' field can be only a forced query to the [value][table].

 
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