MySQL Forums
Forum List  »  Newbie

Re: Finding Rank of score and range of scores
Posted by: Fred Wilson
Date: July 08, 2016 06:50PM

I am not having much luck with the information listed there.

Here is my php segment issuing this query.

No records are returned,.

$sql = "SELECT uo.*, (SELECT COUNT(*) FROM {$Account} ui WHERE (ui.Score * 1) > (uo.Score * 1) AND School_Name = :School_Name AND Class_Name = :Class_Name AS rank) FROM {$Account} uo WHERE School_Name = :School_Name AND Student_Name = :Student_Name AND Class_Name = :Class_Name";
$stmt = $dbh->prepare($sql);
$stmt->execute(array('School_Name' => $School_Name, 'Student_Name' => $Student_Name, 'Class_Name' => $Class_Name));
$stmt->setFetchMode(PDO::FETCH_ASSOC);
$result = $stmt->fetchAll();

Options: ReplyQuote


Subject
Written By
Posted
Re: Finding Rank of score and range of scores
July 08, 2016 06:50PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.