Need help for mysql statement. urgent

yorke1912 · #1 (**permalink**) 10-28-04, 03:58

Hi i need help here...
My sql statement is
$query = "SELECT * FROM ei_module m, ei_student s, ei_result r WHERE r.admin_no LIKE '". $adminno ."' AND r.exam_grade = 'A' AND r.module_code = m.module_code AND s.admin_no = r.admin_no";

what i want to get is

to display results with both Grade A or Grade B.
but i could only get : Grade A but not Grade B
Grade B but not Grade A
what must i do to my mysql statement in order to get the desire result.
Thanks for any kind soul who could help me with it.

yorke1912 · #2 (**permalink**) 10-28-04, 04:16

ermz.. i manage to figure it out le.
My new sql statement is
$query = "SELECT * FROM ei_module m, ei_student s, ei_result r WHERE r.admin_no LIKE '". $adminno ."' AND r.exam_grade <= 'B' AND r.module_code = m.module_code AND s.admin_no = r.admin_no";

But now, my results wasn't in order.. can any one show me the syntax for sorting?
Thanks a lot