WHERE子句错误


WHERE clause error

我试图在HTML表的数据库中显示一个特定的值。声明如下:(这只是一个例子)

$sql = "SELECT * FROM tbl_trainings WHERE tbl_trainings.training='Meat Processing'";

我的问题是我有这样的声明(连接表):

$sql="SELECT 
tbl_info.id, 
tbl_info.firstname, 
tbl_info.middlename, 
tbl_info.lastname, 
tbl_trainings.id,
tbl_trainings.training,
tbl_trainings.info_id
  FROM tbl_info, tbl_trainings
  WHERE tbl_info.id = info_id 
  ORDER BY tbl_info.id";

我试图在下面的语句中插入WHERE tbl_trainings.training='Meat Processing'

$sql="SELECT 
tbl_info.id, 
tbl_info.firstname, 
tbl_info.middlename, 
tbl_info.lastname, 
tbl_trainings.id,
tbl_trainings.training,
tbl_trainings.info_id
  FROM tbl_info, tbl_trainings
  WHERE tbl_info.id = info_id, tbl_trainings.training='Meat Processing'
  ORDER BY tbl_info.id";

但我弄错了。错误为:

警告:mysql_fetch_array()要求参数1为resource,布尔值在C:''wamp''www''CLphpTest''meatproc.php 中给定

有人能帮我纠正一下吗?(对不起,还是一个角落)

提前谢谢。

如果查询中有多个条件,请添加AND/OR,例如

WHERE tbl_info.id = info_id AND
      tbl_trainings.training='Meat Processing'

作为一方,使用新的join语法,

SELECT  tbl_info.id,
        tbl_info.firstname,
        tbl_info.middlename,
        tbl_info.lastname,
        tbl_trainings.id,
        tbl_trainings.training,
        tbl_trainings.info_id
FROM    tbl_info
        INNER JOIN tbl_trainings
            ON tbl_info.id = tbl_trainings.info_id
WHERE   tbl_trainings.training = 'Meat Processing'
ORDER   BY tbl_info.id
Should be "WHERE tbl_info.id = info_id AND tbl_trainings.training='Meat Processing'