
Ponel
Members-
Content Count
29 -
Joined
-
Last visited
Community Reputation
0 NeutralAbout Ponel
-
Rank
Member
-
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
-
Student subject Positioning based on score using php and mysql database
Ponel replied to Ponel's topic in PHP Coding Help
It worked. Thank you sir -
Student subject Positioning based on score using php and mysql database
Ponel replied to Ponel's topic in PHP Coding Help
Ok sir I willl check that out -
Student subject Positioning based on score using php and mysql database
Ponel replied to Ponel's topic in PHP Coding Help
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 ( -
Student subject Positioning based on score using php and mysql database
Ponel replied to Ponel's topic in PHP Coding Help
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. -
Student subject Positioning based on score using php and mysql database
Ponel replied to Ponel's topic in PHP Coding Help
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 -
Student subject Positioning based on score using php and mysql database
Ponel replied to Ponel's topic in PHP Coding Help
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, -
Student subject Positioning based on score using php and mysql database
Ponel replied to Ponel's topic in PHP Coding Help
Bravo.. This worked thanks Mr Barand for your guide and time. God bless you Abundantly sir -
Student subject Positioning based on score using php and mysql database
Ponel replied to Ponel's topic in PHP Coding Help
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 -
Student subject Positioning based on score using php and mysql database
Ponel replied to Ponel's topic in PHP Coding Help
Alright sir. I will try it out -
Student subject Positioning based on score using php and mysql database
Ponel replied to Ponel's topic in PHP Coding Help
I want to select and rank all records where semesterid is 1,2,3 which will allow me to compute the annual ranking -
Student subject Positioning based on score using php and mysql database
Ponel replied to Ponel's topic in PHP Coding Help
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 , -
Student subject Positioning based on score using php and mysql database
Ponel replied to Ponel's topic in PHP Coding Help
Yeah this is what i wanted. I got it thanks.. I need to study the query the is superb. Thank you sir. I appreciate