Multiple rows in grid

Suite and Optimus Suite 5
#1

Hi,

I have the following sqlStatement.

select C.name, C.dayOfWeek, C.startTime, C.endTime, C.year, C.description from class C, student S, classstudent CS where CS.studentId='".$studentId."' and C.id=CS.classId

Currently, there is only 1 row in CS. Therefore, it should return 1 row.

However, the grid displays the same row over and over again.

CS has an id column that is auto-increment (currently for the 1 row, id is 1).

Is there something that I should be setting that doesn’t display that row multiple times in the grid?

Thanks,
K.

#2

Ha, just found the issue after I posted.

It’s the SQL. I forgot to remove the student table from the SQL. Don’t need it.