mysql中使用内部联接的php中的语法错误

问题描述

我有一个带有内部联接的选择查询，我在phpmyadmin中尝试了它，效果很好

i have a select query with inner join i try it in phpmyadmin it work fine

但是当我在浏览器中尝试它时，会显示此错误消息:

but when i try it in the browser it display this error msg :

您的SQL语法有误；在第1行的"SELECT s.specialization_name FROM user u INNER JO"附近使用相应的语法，查看与您的MySQL服务器版本相对应的手册

查询是:

elseif($_POST['listbyq']=="by_specialization")

   {
      $querySrting="SELECT s.specialization_name FROM user u
                             INNER JOIN specialization s
                                         ON u.specialization=s.specialization_id";

      $result = mysql_query($querySrting)  or die("there is an error in this query");
      $queryMSG="showing members with specs";

推荐答案

由于 user 不是保留字，因此很可能是导致错误的外来字符(位于附近INNER JO ).

Since user is not a reserved word, there is most likely a foreign character that is causing the error (located near INNER JO).

这篇关于mysql中使用内部联接的php中的语法错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！