Member Avatar for sowh4t

I need a script that selects all from mysql, orders them DESC with highest money and prints out only where username=$_SESSION['username'],
so it will show
Your position is X/10

  • 2 Contributors
  • 2 Replies
  • 74 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by sowh4t

Recommended Answers

All 2 Replies

Member Avatar for Biiim 
<?php 
$Q = "SELECT * FROM `mysqltable` ORDER BY `money` DESC";
$R = mysql_query($Q);
$i = 1;
if($R !== false){
    while($row = mysql_fetch_assoc($R)){
        //echo "{$row['username']} is position number {$i}<br/>\r\n";
        if($row['username'] == $_SESSION['username']){
            echo "You are position number {$i}<br/>\r\n"; 
        }
        $i++;
    }
}else{
    echo "no results returned :".mysql_error();
}
?>
Edited by Biiim
Member Avatar for sowh4t

thanks a miljon!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.