php - 从列相同的 2 个表中选择数据，查询不太正确？

Question

我正在尝试从prop_slugandprop_gallery_id匹配的 2 个表中获取数据。我已经写了以下语句，但我似乎无法让它工作并不断收到我的语法错误 - 任何人都可以看到我的查询中是否有明显的错误？...

$listings = $db->query('
SELECT * 
  FROM listing_details 
  JOIN prop_gallery 
    ON prop_gallery.prop_gallery_id = listing_details.prop_slug 
 WHERE (listing_details.prop_slug LIKE \'prop_gallery_id\' OR prop_gallery.prop_gallery_id LIKE \'prop_slug\') 
   AND 
 WHERE listing_details.prop_mandate = 1 
 LIMIT 3')->fetchAll();

标签： phpmysqlpdo

Answer 1

你不需要第二个WHERE

$listings = $db->query('
SELECT * 
  FROM listing_details 
  JOIN prop_gallery 
    ON prop_gallery.prop_gallery_id = listing_details.prop_slug 
 WHERE (listing_details.prop_slug LIKE \'prop_gallery_id\' OR prop_gallery.prop_gallery_id LIKE \'prop_slug\') 
   AND listing_details.prop_mandate = 1 
 LIMIT 3')->fetchAll();