Đang Thực Hiện

166610 Quick mySQL / PHP

I have two tables in mysql, 'products' and 'categories'.

'products' -> column[categories] -- contains the category id.

'categories' -> column[id] -> column[name]

the categories column in 'products' lists the category ids in this format: |1|,|2|,|3|

The current query is getting the products from 'products' with an id as the identifier; ie: select stuff from products where id =5

I need someone to write function/query so the categories from the above query can be displayed by name.


|1| = category1

|2| = categories2

|3| = categories3

I need someone to write a function/query to get the name of that specific.

Kĩ năng: Bất kì công việc gì, MySQL, PHP

Xem nhiều hơn: category php id, Mysql php, mysql specific, mysql stuff, write mysql, php function write, mysql quick, quick function, php mysql quick, php stuff, select mysql php, mysql select, column mysql php, write mysql query php, php select query, mysql category, php tables format, specific column mysql php, query mysql, php mysql column, categories mysql php, mysql column column, php select tables category, mysql categories, write mysql query

Về Bên Thuê:
( 27 nhận xét ) Castro Valley, United States

ID dự án: #1912803