help me to change mysql code to php |
can anyone help me changing this code to php?
SELECT a1.mark_id, a1.student_id, COUNT(a2.quiz) Rank FROM mark a1, mark a2 WHERE a1.quiz < a2.mark_quiz OR (a1.mark_total=a2.quiz AND a1.student_id = a2.student_id) GROUP BY a1.student_id, a1.quiz ORDER BY a1.quiz DESC, a1.student_id DESC thanks.
There is no reason why you can't run this query as is:
PHP Code: // In your model
a1.mark_id, a1.student_id, COUNT(a2.quiz) AS Rank
You want to show two simple fields and one aggregated field. Probably the newer MySQL servers would refuse to execute such a query.
|
Welcome Guest, Not a member yet? Register Sign In |