mysqli选择x作为y

Question

在Codeigniter中使用Mysqli，并从Mysql作为新的Mysqli。

下面的Mysql查询抛出了Mysqli错误。我认为这可能与"SELECT x AS y“有关。

$sql = "SELECT uk_postcode_lat AS lat, uk_postcode_long AS long FROM uk_postcodes where uk_postcode_code = '$zip' LIMIT 1";

如何使用Mysqli执行此查询？

Answer 1

long是保留关键字。

尝尝这个

    $sql = "SELECT uk_postcode_lat AS lat, uk_postcode_long AS longitude FROM uk_postcodes where uk_postcode_code = '$zip' LIMIT 1";

Answer 2

我建议用反引号将字段名称括起来。这可以防止MySQL将它们视为关键字-- long是一个关键字。

$sql = "SELECT uk_postcode_lat AS `lat`, uk_postcode_long AS `long` FROM uk_postcodes where uk_postcode_code = '$zip' LIMIT 1";

只需添加反引号，您就可以将long用作字段名，而不会出现任何问题。