Guys on my database i have three tables containing data as shown on a link below. On tables class and subjects, ssid and csid are foreign key from members.
I joining tables using left join as shown in model code shown below. when i echo first_name, suame and class_name for John claudius it appears three times while for Alex massawe it appear only once. but if i add information for Alex massawe result will displayed out as many times as information for Alex massawe that are within subjects. I need your help so that information given out will not be repeated if add information on tables subjects for a person whose name already in tables members.
Tables within database
codes
