To get second largest number from database is easy with mysql query. We can also get second largest number using php code. By using mysql_num_rows() and mysql_result() function this can be obtained.
Database Structure
[code type=php]
<html>
<body>
<?php
$query=mysql_connect(‘localhost’,’root’,”);
mysql_select_db(“freeze”,$query);
$query1=mysql_query(“select name from tb”);
$query2=mysql_num_rows($query1);
$value=$query2-2;
echo mysql_result($query1,$value);
?>
</body>
</html>
[/code]
PHP Code To Get nth Largest Number
As like to get second largest number with simple modification, nth largest number can be obtained.
In line number 8,
- for 3rd largest replace 2 by 3
- for 4th largest replace 2 by 4
- for 5th largest replace 2 by5
- …
- …….
- for nth largest replace 2 by n
Likewise you can get nth largest
$value=$query2-(n);