如何在mysql中选择前1个vaue [英] How to select top 1 vaue in mysql

问题描述

Hello Guys，我想知道如何通过Desc选择MySQL顺序中的前1个值请看我的代码我收到错误而我无法获取值请帮助我谢谢



我尝试了什么：

Hello Guys, I want to know how to select top 1 value in MySQL order by Desc please see my code am getting error and I cannot get values please help me thanks

What I have tried:

<?php
if($_SERVER['REQUEST_METHOD']=='POST'){

include 'DatabaseConfig.php';

 $con = mysqli_connect($HostName,$HostUser,$HostPass,$DatabaseName);




 $CheckSQL = "SELECT * FROM table ORDER BY rank DESC LIMIT 10";
 
 $check = mysqli_fetch_array(mysqli_query($con,$CheckSQL));
 if(isset($check)){
 echo 'Error';
//$Sql_Query = "INSERT INTO users (id) values ('$F_name'+$check)";
 }
else{ 
$Sql_Query = "INSERT INTO complain (complainno) values ('$check')";

 if(mysqli_query($con,$Sql_Query))
{
 echo 'Registration Successfully';
}
else
{
 echo 'Something went wrong';
 }
 }
}
 mysqli_close($con);
?>

推荐答案

_SERVER ['REQUEST_METHOD'] =='POST'）{

包括'DatabaseConfig.php';

_SERVER['REQUEST_METHOD']=='POST'){ include 'DatabaseConfig.php';

con = mysqli_connect（

con = mysqli_connect(

HostName，

这篇关于如何在mysql中选择前1个vaue的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！