php - SQL 语法错误 select * from

Question

我的代码抛出此错误:

Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-contact-info' at line 1

我的代码:

<?php

    //connect
    $connection = mysqli_connect("myh","myu","myp","mydb") or die("Error " . mysqli_error($connection));

    //consultation: 
    $query = "SELECT * FROM web-contact-info"; 

    //execute the query. 
    $result = mysqli_query($connection, $query);
    if (!$result) {
        printf("Error: %s\n", mysqli_error($connection));
        exit();
    }

    //display information: 
    while($row = mysqli_fetch_array($result)) { 
      echo $row["live_name"] . "<br>"; 
    } 

    ?>

我尝试在 web-contact-info 周围加上引号，但得到了略有不同的错误:

Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''web-contact-info'' at line 1

我写错了什么？

Answer 1

你可以试试这个:

SELECT * FROM `web-contact-info`

由于 mysql_* 已弃用，请考虑切换到 mysqli或PDO .