AbanteCart Community

Shopping Cart Operations => Support => Topic started by: psusinbuts on March 16, 2017, 05:34:09 AM

Title: SQL for getting product image urls
Post by: psusinbuts on March 16, 2017, 05:34:09 AM

I want to make a SQL query to get image urls from a given product id, but i cant seem to find in what table are product_ids linked to resource_ids. Any help would be great.

Thanks

Title: Re: SQL for getting product image urls
Post by: abolabo on March 16, 2017, 07:18:01 AM

you should find table resource_map in your database. There columns object_name (products) and object_id (product_id)