i have sql command and want to show for category_id, type and plattform sold not id but corresponding name
command
select id2, name, street, category_id, type, plattform_sold, archivedate from assets where published=2 order by archivedate desc
table assets
id
street
category_id (need [login to view URL] here)
type (need [login to view URL] here)
platform_sold (need [login to view URL] here)
category table
id, name,
type table
id, name
plattform table
id, name
Hello,
I am available right now. I can do the right job. You can trust me. This is my field of studies. I have 5 years experience on development.
Thanks in advance.
Best regards,