evanpyrz_jm

Hi there, Okay so I have a recordset created in dreamweaver, displaying a "repeating" table with results from the recordset. What I am looking to figure out is how to replicate that "dynamic dropdown menu" functionality, but just for the results. The situation: Transactions table has a field called "concert_id_link" which has the primary key from the table "Concerts". Right now, I just have it echoing that result "<?php echo $row_GetTransactions['concert_id_link']; ?>". What's the best way to have it retrieve the "title" field from the concerts table, based on that primary key echo from the transactions recordset? Thanks much in advance for you guidance!

Hi all, Okay, I'll try to explain briefly but thoroughly on what I'm trying to do. FYI I have a general working knowledge of PHP & mySQL, and use Dreamweaver and it's built-in tools regularly. I have a registeration form, which gives the option to register into 4 age groups (via a radio button), which just submits as text into the database. What I am looking to be able to do is "Show If" (I think?) a disabled="true" to disable a radio button, once a certain amount of records have been submitted for a specific group. So I'm assumming the way to do this is to call up the full list from the database (not very many entries) and check if the limit of 15 per age group is reached? Let me know if that makes sense, any if you can give me any guidance. It will be much appreciated! Also, if you have the time to explain your coding to me too, so I can learn from it, that would be great! --EVP