MAX Count im Stumped....

[Dethman]

<?php
if($player['raceID']==1){
$q = "select `username` from `user_users` where vote_count=(SELECT MAX(`vote_count`) FROM `user_users` where `raceID`='1')";
$leader = mysql_query($q) or trigger_error(mysql_error());
if( $leader ){
echo($leader);
}
else{
echo('None');
}

}
if($player['raceID']==2){
$q = "select `username` from `user_users` where vote_count=(SELECT MAX(`vote_count`) FROM `user_users` where `raceID`='2')";
$leader = mysql_query($q) or trigger_error(mysql_error());
if( $leader ){
echo($leader);
}
else{
echo('None');
}
}
if($player['raceID']==3){
$q = "select `username` from `user_users` where vote_count=(SELECT MAX(`vote_count`) FROM `user_users` where `raceID`='3')";
$leader = mysql_query($q) or trigger_error(mysql_error());
if( $leader ){
echo($leader);
}
else{
echo('None');
}
}
if($player['raceID']==4){
$q = "select `username` from `user_users` where vote_count=(SELECT MAX(`vote_count`) FROM `user_users` where `raceID`='4')";
$leader = mysql_query($q) or trigger_error(mysql_error());
if( $leader ){
echo($leader);
}
else{
echo('None');
}
}
?>

 

 

For Some reason this is not working right it displayes this

 

 

Resource id #9 

 

Please Help... :'(

 

[kenrbnsn]

After doing a mysql_query, you have to use one of the mysql_fetch functions to actually get the data.

 

For example:

<?php
if($player['raceID']==1){
      $q = "select `username` from `user_users` where vote_count=(SELECT MAX(`vote_count`) FROM `user_users` where `raceID`='1')";
      $leader = mysql_query($q) or trigger_error(mysql_error());
      if(mysql_num_rows($leader) > 0 ){
   $rw = mysql_fetch_assoc($leader);
          echo $rw['username'];
      }
      else{
   echo 'None';
     }
}
?>

 

Ken

}

[Wolphie]

Please mark your other topics as solved before creating a new very similar topic. Or, just update older topics.