hi

i'm developing a webpage.page contains various fields like collegename ,studentname and so on.collegename field will be a dropdown box and it gets option from backend table collegedetails.every collegename will have a unique collegeid in collegedetails table.after selecting collegename and filling necessary fields in webpage the details should be stored in data base but instead of collegename ,college id should be stored in another database table called studentdetails.so how to get collegename and college id in key value pairs

hi

i'm developing a webpage.page contains various fields like collegename ,studentname and so on.collegename field will be a dropdown box and it gets option from backend table collegedetails.every collegename will have a unique collegeid in collegedetails table.after selecting collegename and filling necessary fields in webpage the details should be stored in data base but instead of collegename ,college id should be stored in another database table called studentdetails.so how to get collegename and college id in key value pairs

What you want to do???
Retrieve values from database and show on page????
or insert data to database with the value comes from page???
FIELDS??? field- this type have many other subtype which one you are pointing to???

Expand your database, do not relay on single table to keep all data. Create table for colleges where you will store college ID, name, contact details. Something along the line as showed in this tutorial

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.