从mysql表中提取id [英] extracting id's from a mysql table
本文介绍了从mysql表中提取id的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
抱歉,这个问题看起来很简单,但我对 php 很陌生,我试图在索引页中显示排名,但我不知道如何从 中的列中提取 id一张桌子,有两张桌子:
sorry for this question it may seem very simple but I'm very new in php, I'm trying to make a ranking appear in the index page, but I don't know how to extract the id's from a column in a table, there's 2 tables:
- raking table -
city = 'Boston'
ranking_name = 'the best 5 places'
business_ids = '67,43,1,6,78'
- business table -
business_id = '67'
business_name = 'planet pizza'
如何在前面显示这样的内容:
How do I display in the front something like this:
<ul>
<h2>the best 5 places</h2>
<li><span>1</span><?php echo $business_name ?></li>
<li><span>2</span><?php echo $business_name ?></li>
<li><span>3</span><?php echo $business_name ?></li>
<li><span>4</span><?php echo $business_name ?></li>
<li><span>5</span><?php echo $business_name ?></li>
</ul>
我已经在表中提供了 ID,所以我需要一些非常相似的东西,任何人都可以帮助我.
I already have the id's in the table so I need something very similar, can anyone pls help me.
感谢所有帮助问候
推荐答案
尝试使用此查询
SELECT * FROM business_table WHERE business_id IN ( SELECT business_id FROM ranking_table WHERE city='Boston' );
参见演示
你的代码,
$con=mysqli_connect("HOSTNAEM","USERNAME","PASSWORD","DB") die('Could not connect: ' . mysql_error());
$query = "SELECT * FROM business_table WHERE business_id IN ( SELECT business_id FROM ranking_table WHERE city='Boston' )";
while($row = mysqli_fetch_array($query))
{
echo '<li><span>1</span>'+$row['$business_name']+'></li></br>';
}
这篇关于从mysql表中提取id的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文