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>
I already have the id's in the table so I need something very similar, can anyone pls help me.
Appreciate all the help Regards