Question

Closed. This question needs details or clarity. It is not currently accepting answers.

通过

Closed 9 years ago.

表格categories(TABLE_CATEGORIES),有田地:categories_id,oul_id

表categories_description(TABLE_CATEGORIES_DESCRIPTION), 这些领域:categories_id,categories_name

如今,根据<代码>,$=父母_id 我想得到<条码>分类——姓名和<条码> 分类_id,这是我的指挥,但显示的是图马尔错误。

$query = "select c.categories_id, cd.categories_name from " .
TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd
                          where c.categories_id=cd.categories_id and c.parent_id=".$cPath;

the error:1064 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 at line 2

Answer 1

你们应当使用

SELECT cd.categories_id, cd.categories_name
FROM `TABLE_CATEGORIES_DESCRIPTION` cd 
    INNER JOIN `TABLE_CATEGORIES` c
    ON cd.categories_id = c.categories_id
WHERE c.parent_id = your_id

EDITED to reflect modified user question:
Are you sure that both "TABLE_CATEGORIES" and "TABLE_CATEGORIES_DESCRIPTION" don t contain white spaces or strange chars?
If so you must enclose them with backticks.

Answer 2

内部加入可以帮助......

SELECT c.categories_id, cd.categories_name FROM TABLE_CATEGORIES c INNER JOIN TABLE_CATEGORIES_DESCRIPTION cd ON c.categories_id=cd.categories_id where c.parent_id=$cPath

请检查该法典:

月度=“当选人......id, cd.categories_name from” TABLE_CATEGORIES . “c. TABLE_CATEGORIES_DESCRIPTION . “cd where c.categories_id=cd.categories_id and c.oul_id=“$cPath>;

友情链接