如何从我选择的cat_id中调用cat_name？ MYSQL [关闭]

Question

Below i made a MySQL Table in my phpmyadmin.

I want to print on my php page the cat_name of a cat_id of my choosing. What code would i use exactly for that? I am looking at this guide here But i am not figuring it out completely maybe someone can guide me in the right direction?

Answer 1

You need to use WHERE clause for this. Basically what it does is it filters the records you want.

SELECT Cat_Name
FROM category
WHERE CAt_ID = 1   -- place the value of your desired category id