Php mysql select highest quotient

[jackr1909]

Hi everyone,

 

i have some mysql data and i want to select the highest, second highest, third highest, etc...... quotient of two records in the same row and echo them, for example,

<?php
$link = MYLINK;
$result = mysql_query("select * from posts WHERE {//this is where it gets tricky// intel/age = highest}");
while($row = mysql_fetch_array($result)){
echo $row['username'];
echo "has a value of";
$row['intel']/$row['age'];
}
echo "<br>";
$result2 = mysql_query("select * from posts WHERE {//this is where it gets tricky// intel/age = second higest}");
while($row = mysql_fetch_array($result2)){
echo $row['username'];
echo "has a value of";
$row['intel']/$row['age'];
}
//This will continue for an indefinite number of times, multiplied by a get value (i've got it under control)
?>

Thanks a lot,

Jack

[kickstart]

Hi

 

Select the calculated value and order by that descending. Then use a limit clause on the select?

 

Not 100% sure that will give you what you want (ie, if you wanted the top 10, if will give you the top ten rows, rather than the rows with the top ten values if those values are duplicated).

 

All the best

 

Keith

[jackr1909]

Alright, what i want is the highest row fitting that calculation. I'll work upwards from there, is there any way that i can calculate that in mysql

 

Thanks,

 

Jack

[kickstart]

Hi

 

Highest is easy:-

 

SELECT *, intel/age 
FROM posts 
ORDER BY intel/age DESC
LIMIT 1

 

All the best

 

Keith

[jackr1909]

Thankyou sooo much,

 

Jack