我对在MySQL中使用联接相对来说还是比较新的。
我有两张桌子:
sh_subscriptions
=> id
=> user_id
=> feed_id
sh_feeds
=> id
=> shop_name
=> feed_id我试图从sh_subscriptions获取所有字段,其中feed_id对应于sh_feed中的feed_id,后者对应于$row['shop_name'],而user_id对应于$id['id]。
以下是我的尝试:
SELECT * FROM sh_subscriptions s
INNER JOIN sh_feeds f ON s.shop_id = f.feed_id
WHERE s.id = '" . $id['id'] . "'
AND f.shop_name = '" . $row['shop_name'] . "'更新
我现在有以下几点:
while($row = mysqli_fetch_array($query))
{
echo "<div class='col-md-4'>";
echo $row['shop_name'] . " ";
$query = mysqli_query($con, "SELECT * FROM sh_subscriptions s INNER JOIN sh_feeds f ON s.feed_id = f.feed_id WHERE s.user_id = '" . $id['id'] . "' AND f.shop_name = '" . $row['shop_name'] . "'") or die(mysql_error($con));
echo "</div>";
}我可以确认数据库字段都存在,变量正在正确地打印出来,但是尽管包含了一个错误处理程序,但div中没有任何内容被打印出来。
发布于 2014-04-21 12:24:35
试试这个:
SELECT * FROM sh_subscriptions s
INNER JOIN sh_feeds f ON s.id = f.feed_id
WHERE s.id = '" . $id['id'] . "'
AND f.shop_name = '" . $row['shop_name'] . "'") or die(mysql_error($con));发布于 2014-04-21 12:25:10
我觉得应该是
SELECT * FROM sh_subscriptions s
INNER JOIN sh_feeds f ON s.feed_id = f.feed_id
WHERE s.id = '" . $id['id'] . "'
AND f.shop_name = '" . $row['shop_name'] . "';https://stackoverflow.com/questions/23197356
复制相似问题