translate phpmyadmin syntax table.field


translate phpmyadmin syntax table.field

我尝试执行此查询:

SELECT * FROM persona ORDER BY ´id´ DESC LIMIT 0,5;

但它以 ASC(而不是 DESC(返回结果

我使用PhPmyAdmin的图形界面尝试了它,最后我得到了它:

SELECT * FROM persona ORDER BY ´persona´.´id´ DESC LIMIT 0,5;

它与该语法(persona.id(完美配合,但在PHP代码中它不起作用。

如何才能将PhPmyAdmin语法(persona.id(翻译成我的PHP代码而没有错误?


这是PHP代码:

   <?php
                $sql="SELECT * FROM personas ORDER BY '".$_SESSION['campo']."' ".$_SESSION['orden']." LIMIT ".$_SESSION['registro'].",5";
                $result = $con->query($sql);
                if($result->num_rows > 0){
                    while($row=$result->fetch_assoc()){ 
                        echo '<tr>
                                <td>'.$row['id'].'</td>
                                <td>'.$row['apellido1'].' '.$row['apellido2'].'</td>
                                <td>'.$row['nombre'].'</td>
                                <td>'.$row['telefono'].'</td>
                    }
                }
                mysqli_close($con);
            ?>

我用 session_start((; 等开始了会话问题是$sql=.。行,这适用于 ASC,如果我写:

    $sql="SELECT * FROM personas ORDER BY 'persona'.'".$_SESSION['campo']."' ".$_SESSION['orden']." LIMIT ".$_SESSION['registro'].",5";

或者例如,角色中没有":

    $sql="SELECT * FROM personas ORDER BY persona.'".$_SESSION['campo']."' ".$_SESSION['orden']." LIMIT ".$_SESSION['registro'].",5";

它返回一个错误并且不执行查询...

谢谢你帮我:)让我们再试一试

最后我做到了,用''语法,而不是''

    $sql = "SELECT * FROM `personas` ORDER BY `personas`.`".$_SESSION['campo']."` ".$_SESSION['orden']." LIMIT ".$_SESSION['registro'].",5";

感谢大家的支持和尝试:)