Guest User

Untitled

a guest
Mar 23rd, 2018
120
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.41 KB | None | 0 0
  1. order by cast(score as int) desc
  2.  
  3. $servername = "localhost";
  4. $username = "tabulati_user";
  5. $password = "Star51@#";
  6. $dbname = "tabulati_ats";
  7. // Create connection
  8. $conn = new mysqli($servername, $username, $password, $dbname);
  9.  
  10. $catId = $Categories->id;
  11. $sqlRank = "SELECT * FROM rankings where catId='".$catId."' and judId='".$judgeId."' order by cast(score as int) desc";
  12. $resultRank = $conn->query($sqlRank);
Add Comment
Please, Sign In to add comment