如何显示此ID的名称

Question

I have a problem not displayed the name for id

data base structure for category_list

id   name
1    php 
2    mysql
...  ...
10   html

and data base structure for entries

category_id
     8    
     5

for the results i have this code, this script displays the ID

as a result it shows 2 , but i want the following to be displayed: mysql

but I want to show name for this ID , instead of ID

Answer 1

We need to use a join query to get the category name for given id, e.g.:

select c.name 
from category_list c join entries e on c.id = e.category_id
where category_id = ?