[PHP] Get highest player from MYSQL Database

[atyll]

Hello Guys

I have managed to get total number of players:

<?php
								$SQL = AAC::$SQL;
								$SQL->myQuery('SELECT players.sex, COUNT(players.id) as number FROM `players` GROUP BY players.sex');
                $total = 0;
                while ($a = $SQL->fetch_array()) {
                    $genders[$a['sex']] = $a['number'];
                    $total += $a['number'];
                }
				$gender_names = array(0 => 'Female',1 => 'Male');
				echo "$total";
               
								
								?>

However, I can't manage to get player with highest level and skill (get Highest Level and Name).
Anybody would be able to help?

Regards
Jakub

 

[Cykotitan]

SELECT `name`, `level` FROM `players` ORDER BY `level` DESC, `experience` DESC LIMIT 1

assuming you don't want gender involvement

 

[atyll]

Doesn't work.
I use this code and shows just 0.

<?php
$SQL = AAC::$SQL;
$SQL->myQuery('SELECT `name`, `level` FROM `players` ORDER BY `level` DESC, `experience` DESC LIMIT 1');
                $total = 0;
                while ($a = $SQL->fetch_array()) {
                    $level[$a['level']] = $a['number'];
                    $total += $a['number'];
                }
				echo "$total";
               ?>

 

[Cykotitan]

there's no number, your PHP code/loop is wrong the columns are name and level

 

[atyll]

I have no idea how to put this into code, can you help?

 

[Xon vanetta]

$SQL->myQuery('SELECT `name`, `level` FROM `players` ORDER BY `level` DESC, `experience` DESC LIMIT 1')->fetch();

echo 'Rank 1: '.$SQL['name'].' Level: '.$SQL['level'];

this runs it and echo its out i dont se any problem with it from here XD
didnt do it in any editor so cant se if its wrong

 

[atyll]

Fatal error: Call to a member function fetch() on a non-object in C:\xamppp\htdocs\test\menu2.html on line 283

 

[Cornex]

Try

$query = $SQL->query("SELECT * FROM `players` WHERE `group_id` < 3 ORDER BY `experience` DESC")->fetch();

 

[atyll]

Fatal error: Call to undefined method SQL::query() in C:\xamppp\htdocs\test\menu2.html on line 283

 

[Xon vanetta]

$query = $SQL->myQuery("SELECT * FROM `players` WHERE `group_id` < 3 ORDER BY `experience` DESC")->fetch();

echo 'Rank 1: '.$query['name'].' Level: '.$query['level'];

 

[atyll]

And once again, sorry to be pain, guys

Fatal error: Call to a member function fetch() on a non-object in C:\xamppp\htdocs\test\menu2.html on line 283

 

[Xon vanetta]

$query = $SQL->myQuery("SELECT * FROM `players` ORDER BY `experience` DESC")->fetch();
        echo 'Rank 1: '.$query['name'].' Level: '.$query['level'];

i tested it and it worked. i think the gruop_id is something you dont have

 

[EvulMastah]

$query = $SQL->myQuery("SELECT * FROM `players` ORDER BY `experience` DESC")->fetch();
        echo 'Rank 1: '.$query['name'].' Level: '.$query['level'];

i tested it and it worked. i think the gruop_id is something you dont have

Why the fuck would you include fetch() everytime knowing the error?

 

[atyll]

Your code didn't work for me, sorted it out myself.

HOWEVER, I don't how to get Skills and name of the player with highest skill now
This is the code I use to get level:

<?php
							
$data = mysql_query("SELECT * FROM `players` ORDER BY `experience` DESC") 
or die(mysql_error()); 

$info = mysql_fetch_array( $data ); 
Print "<b>Top:</b> ".$info['name'] . " "; 
Print "<br /><b>Level:</b> ".$info['level'] . " "; 
		
?>

How can I use this code, to pick from player_skills, order by skill 5 (shielding) and get highest value?
Thanks in advance for help, guys!

 

[troja]

Your code didn't work for me, sorted it out myself.

HOWEVER, I don't how to get Skills and name of the player with highest skill now
This is the code I use to get level:

<?php
							
$data = mysql_query("SELECT * FROM `players` ORDER BY `experience` DESC") 
or die(mysql_error()); 

$info = mysql_fetch_array( $data ); 
Print "<b>Top:</b> ".$info['name'] . " "; 
Print "<br /><b>Level:</b> ".$info['level'] . " "; 
		
?>

How can I use this code, to pick from player_skills, order by skill 5 (shielding) and get highest value?
Thanks in advance for help, guys!

<?php
							
$data = mysql_query("SELECT * FROM player_skills WHERE skillid = 5 ORDER BY value DESC") 
or die(mysql_error()); 


$info = mysql_fetch_array( $data ); 

$data2 = mysql_query("SELECT name FROM players WHERE id = ".$info['player_id']."") 
or die(mysql_error()); 

$info2 = mysql_fetch_array( $data2 ); 

Print "<b>Top:</b> ".$info2['name'] . " "; 
Print "<br /><b>Level:</b> ".$info['value'] . " "; 
		
?>

mby something like this, there's probably some faster way but i don't know how to multiple tables etc because im a noob;P<3

 

[Xon vanetta]

Why the fuck would you include fetch() everytime knowing the error?

the error is that the query didnt work/return the values and that means the Query is wrong... or he didnt use PDO at all XD

 

[atyll]

@troja

The output I get is:

Top: ".$info['name'] . " "; Print "
Level: ".$info2['value'] . " "; ?>

 

[Xon vanetta]

@troja

The output I get is:

Top: ".$info['name'] . " "; Print "
Level: ".$info2['value'] . " "; ?>

echo "<b>Top:</b> ".$info2['name']."<br />"; 
echo "<b>Level:</b> ".$info['value'];

this should do it

 

[atyll]

@up


Now I get

Top: ".$info2['name']."
"; echo "Level: ".$info['value']; ?>

- - - Updated - - -

OMG I found the error, very silly...

I had <? php instead of <?php

Thanks a lot for help guys!
You can check what I did on http://danera.no-ip.org

God bless you all!