Ponel

https://ravemodal-dev.herokuapp.com/hosted/redirect-payment?flwref=FLW-MOCK-ba043ffda2fad8a96ddd82b6c2a3dc5a&txref=996419 txref=996419 from the link is auto generated reference number

redirect is a page to redirect to after successful payment

Good afternoon everyone, Please I’m trying to integrate a rave pay payment gateway and i’m getting this below error on making payment Error: Cannot POST /hosted/redirect My redirect page code (redirect.php) <?php //session_start(); include 'includes/global/login_handler.php'; include 'includes/global/randStrGen.php'; if (isset($_GET['txref']) && isset($_SESSION["amount_to_pay"]) && isset($_SESSION["txtrefno"]) && isset($_SESSION["transact_no"]) && isset($_SESSION["buyer_email"]) && isset($_SESSION["buyer_name"]) && i

It worked. Thank you sir

Ok sir I willl check that out

yeah that's for overall position for class. I'm talking of the subject position in the column. With this SELECT yearid , semesterid , regno , subjectid , rank , total , grade , comment FROM ( SELECT yearid , semesterid , subjectid , @seq := CASE WHEN yss <> @prev THEN 1 ELSE @seq + 1 END as seq , @rank := CASE WHEN total = @prevtot THEN @rank ELSE @seq END as rank , @prevtot := total as total , @prev := yss as yss , regno , armsLevelId -- added , armsid -- added FROM (

Ok sir. Look at the Sub Position column. and the number of student is in a class is 34 so we have 49th and 47th which is higher than number of student.

Is there a way whereby user 7566 and 7057 that takes on rank 3, the next user which is 9208 and 7664 will take on rank 4 and so on so that the number of rank will not be more than the number of student in a class

Compliment of the season Mr Barand. Thank you for your guide so far. I appreciate that. Please i wanted to ask, how can one resolve ties in ranking? I have the table DROP TABLE IF EXISTS `subject_position`; CREATE TABLE IF NOT EXISTS `subject_position` ( `id` int(11) NOT NULL AUTO_INCREMENT, `regNo` int(50) NOT NULL, `subjectid` int(50) NOT NULL, `armsLevelId` int(50) NOT NULL, `armsId` int(50) NOT NULL, `semesterid` int(50) NOT NULL, `yearid` int(50) NOT NULL,

Bravo.. This worked thanks Mr Barand for your guide and time. God bless you Abundantly sir

I wrote this by removing all the semesterid in the where clause and i got this output SELECT yearid , semesterid , regno , total , rank , numstudents as `Total students` , grade as `Average grade` , comment FROM ( SELECT yearid , semesterid , @seq := CASE WHEN yss <> @prev THEN 1 ELSE @seq + 1 END as seq , @rank := CASE WHEN total = @prevtot THEN @rank ELSE @seq END as rank , @prevtot := total as total , @prev

Alright sir. I will try it out

I want to select and rank all records where semesterid is 1,2,3 which will allow me to compute the annual ranking

I have student table Already sir. if i want to calculate the overall semesterid, yearid, armslevelid, armsid. and rank the student for 1st term, 2nd term and 3rd term result. this is my query SELECT yearid , semesterid , regno , total , rank , numstudents as `Total students` , grade as `Average grade` , comment FROM ( SELECT yearid , semesterid , @seq := CASE WHEN yss <> @prev THEN 1 ELSE @seq + 1 END as seq ,

Yeah this is what i wanted. I got it thanks.. I need to study the query the is superb. Thank you sir. I appreciate