get info for most active user?

[homer09001]

i want to make a script that will get the info for the most active user and display it heres my code so far:

<?php
$maxuser = mysql_query("SELECT MAX(pireps) FROM pilotinfo",$mysql);
$rw = @mysql_fetch_array($maxuser)or die("Didnt work");
echo("Pilot Name:$temp13<br>Rank: $rank");
?>

but with that all im getting returned is the value of 3 which is the highest value of pireps

how can i get it to retrieve all the information?

[rincewind456]

You need something like

SELECT pilot_name, MAX(pipereps) from pilotinfo where pilot_name = 'Pilots Name'

[homer09001]

$maxuser = mysql_query("SELECT 'id', 'name', 'hours', MAX(pireps) FROM pilotinfo",$mysql);
$rw = @mysql_fetch_array($maxuser)or die("We are sorry but either the name you entered doesn't match your record on our server (check the roster) or we have no record of that name on the server");

that my new code it still not returning anything if i echo $rw i get the word Array?

[rincewind456]

Yes thats because $rw is an array of id, name, hours and maxpipreps

 
id // is $rw[0]
name //is $rw[1]
hours // is $rw[2]
MAX(pireps) // is $rw[3].

[homer09001]

ok tryed what you said and ehres the code:

<?php
$maxuser = mysql_query("SELECT 'id', 'name', 'hours', MAX(pireps) FROM pilotinfo",$mysql);
$rw = @mysql_fetch_array($maxuser)or die("We are sorry but either the name you entered doesn't match your record on our server (check the roster) or we have no record of that name on the server");

$temp1 = $rw['0'];
$temp2 = $rw['1'];
$temp3 = $rw['2'];
$temp4 = $rw['3'];
echo "$temp1, $temp2, $temp3, $temp4";
?>

and whats parsed:

id, name, hours, 7

[homer09001]

idealy what i need is it to SELECT * FROM pilotinfo WHERE MAX(pireps)
but that wont work

[rincewind456]

Sorry I'm not with it this morning, I was assuming you were using mysql_fetch_row, in which case what I said would be right.

[homer09001]

ok but whats confusing me is why $temp0, $temp1 and $temp2 are not reurning the values of teh row that contains MAX(pireps) its leteraly returnign teh columnname not the rows contents for that field?

[homer09001]

GOT IT i simply query tyhe database for the MAX(pireps) and then queryed it again where pireps = the MAX(pireps) heres me code:

$maxuser = mysql_query("SELECT MAX(pireps) FROM pilotinfo",$mysql);
$rw = @mysql_fetch_array($maxuser)or die("We are sorry but either the name you entered doesn't match your record on our server (check the roster) or we have no record of that name on the server");

$pirps = $rw['0'];

$maxuser = mysql_query("SELECT * FROM pilotinfo WHERE pireps='$pirps'",$mysql);
$rw2 = @mysql_fetch_array($maxuser)or die("We are sorry but either the name you entered doesn't match your record on our server (check the roster) or we have no record of that name on the server");

$temp0 = $rw2['id'];
$temp1 = $rw2['name'];
$temp2 = $rw2['hour'];
$temp3 = $rw2['pireps'];

if ($temp2 < 2000)
{
$val = "2000";
$rank = '<img src="http://danhill.frihost.net/easyjetv/images/pilot.jpg"><br><b>Trainee 2nd Officer</b>';
} 
elseif ($temp2 < 6000)
 {
$val = "6000";
$rank = '<img src="http://danhill.frihost.net/easyjetv/images/second.jpg"><br><b>Second Officer</b>';
} 
elseif ($temp2 < 8000)
 {
$val = "8000";
$rank = '<img src="http://danhill.frihost.net/easyjetv/images/first.jpg"><br><b>First Officer</b>';
} 
elseif ($temp2 < 10000)
 {
$val = "10000";
$rank = '<img src="http://danhill.frihost.net/easyjetv/images/capt.jpg"><br><b>Captain</b>';
} 
elseif ($temp2 < 12000)
 {
$val = "12000";
$rank = '<img src="http://danhill.frihost.net/easyjetv/images/scapt.jpg"><br><b>Senior Captain</b>';
}
elseif ($temp2 = 440887)
{
$val = "440887";
$rank = '<img src="http://danhill.frihost.net/easyjetv/images/scapt.jpg"><br><b>Senior Captain/CEO</b>';
}
$hours2 = "$temp2"/60;

$number = "$hours2";
// english notation without thousands seperator
$hours3 = number_format($number, 1, '.', '');
// 1234.57

echo "<br><b><u>Most Active Pilot</u>";
echo "<br>Pilot Id: $temp0<br>Name: $temp1<br>Total Flight Hours: $hours3<br>Rank: $rank<br>Pireps Filed: $temp3</b>";
?>

[rincewind456]

It's because you haven't specified a result_type in the parameters of your mysql_fetch_array, it therefore defaults to MYSQL_BOTH. so your array would look like

Array (
[0] => 001 [id] => 001
[1] => Fred [name] => Fred 	
[2] => 100 [hours] => 100 
[3] => 7 [MAX(pipereps)] => 7)

Whereas if you had used mysql_fetch_row or your mysql_fetch-array statement was like this

$rw = @mysql_fetch_array($maxuser, MYSQL_Num)or die()

then your array would look like

Array (
[0] => 001
[1] => Fred 	
[2] => 100 
[3] => 7 

[homer09001]

ive got it working now thanks anyway one more thing
do you have a link to an easy to follow Pagination Tutorial?