Fill list from different table based on primary id
<p>I have 3 table which have relation with each others... In 1st table, i have student details contains studentid (PK), studentname, dob, etc... </p>

<p>Table 2 contain course consist of coursecodeid(PK), studentid(FK), coursename, teachername and etc..</p>

<p>Table 3 contain grade consist of studentid(fk), courseid(fk), id(pk_autoincrement) and grade.</p>

<p>When system starts, studentid will be load into a dropmenu. Onchange this dropmenu, second dropmenu will be shown and load with courseid take by selected student (based on studentid) </p>

<p>When user select courseid onchange a label will be visible to show student grade. </p>

<p>Everything done in 1 page... Anybody can give me sample code either in php or javascript since i am using php and mysql database.</p>
