我们如何从mysql数据库中搜索最多10条记录 [英] how can we search maximum 10 record from mysql database

问题描述

我有学生的记录，我需要先计算前10名学生。我可以从mysql数据库中检索这类记录

i have record of student by which i need to count first top 10 students.how can i retrive this type of record from mysql database

<?php
include("config.php");

$total = "select Total from student";
$x= mysql_query($total);

while($t = mysql_fetch_array($x))
{
    $numbers[] =$t['Total'];

    function maxN(array $numbers, $n)
    {
        $maxHeap = new SplMaxHeap;
        foreach($numbers as $number)
        {
            $maxHeap->insert($number);
        }
        return iterator_to_array(new LimitIterator($maxHeap, 0, $n));
    }
    print_r( maxN( $numbers, 10 ) );

}


//print_r( maxN( array(7,54,2,4,26,7,82,4,34,99,21,67), 4 ) );

$merit = "select merit from student";
$result = mysql_query($merit);

while($raw = mysql_fetch_array($result))
{

}

?>

推荐答案

总计 = 从学生中选择总数;

x = mysql_query（

x= mysql_query(

total ）;

while（

total); while(

这篇关于我们如何从mysql数据库中搜索最多10条记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！