如何使用mysql_fetch_assoc处理php中的记录？

i am trying to retrieve subject names, there are two types of subjects optional and main. Each student contains optional and main subjects. by using those subject ids i can retrieve the name from subject table. But in this result only one optional subject name is appearing, is there any problem in my code? pls help me i am trying to retrieve subject names, there