[Skip to main content](#vessel-content) # More Products by this artist ## - **[YakNarak](/forum/user/476-yaknarak "View YakNarak's Profile")** - [![YakNarak's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/476-yaknarak "View YakNarak's Profile") Topic Author - [ Offline](/forum/user/476-yaknarak) Less More - Posts: 86 - Thank you received: 0 - - 15 years 8 months ago [\#8015](#8015) by [YakNarak](/forum/user/476-yaknarak "View YakNarak's Profile") *[More Products by this artist](/forum/2-general-talk-about-hikashop/8015-more-products-by-this-artist#8015 "Hi Nicholas, I'm trying to show three more products from an artist on the product detail page. I thought it worked well, until I found out that when an artist doesn't have three products, some other products not from the same artist are shown. Am I doing something wrong or is this a bug. Please see the definition attached. Gert.")* was created by *[YakNarak](/forum/user/476-yaknarak "View YakNarak's Profile")* Hi Nicholas, I'm trying to show three more products from an artist on the product detail page. I thought it worked well, until I found out that when an artist doesn't have three products, some other products not from the same artist are shown. Am I doing something wrong or is this a bug. Please see the definition attached. Gert. image missing http://www.hikashop.com/media/kunena/attachments/legacy/images/More_Products.jpg - [ ![More_Products.jpg](/forum/attachment/490) ](/forum/attachment/490 "More_Products.jpg") [ ](/forum/attachment/490?download=1 "More_Products.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwMTUtbW9yZS1wcm9kdWN0cy1ieS10aGlzLWFydGlzdD90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86322 - Thank you received: 14281 - - 15 years 8 months ago [\#8029](#8029) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: More Products by this artist](/forum/2-general-talk-about-hikashop/8015-more-products-by-this-artist#8029 "Hi Nicholas, I'm trying to show three more products from an artist on the product detail page. I thought it worked well, until I found out that when an artist doesn't have three products, some other products not from the same artist are shown. Am I doing something wrong or is this a bug. Please see the definition attached. Gert.")* Hi, You need to publish your module in the option "Modules under the product page" in the config under the tab display and not as a normal joomla module. Is that the case ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwMTUtbW9yZS1wcm9kdWN0cy1ieS10aGlzLWFydGlzdD90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[YakNarak](/forum/user/476-yaknarak "View YakNarak's Profile")** - [![YakNarak's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/476-yaknarak "View YakNarak's Profile") Topic Author - [ Offline](/forum/user/476-yaknarak) Less More - Posts: 86 - Thank you received: 0 - - 15 years 8 months ago [\#8234](#8234) by [YakNarak](/forum/user/476-yaknarak "View YakNarak's Profile") Replied by *[YakNarak](/forum/user/476-yaknarak "View YakNarak's Profile")* on topic *[Re: More Products by this artist](/forum/2-general-talk-about-hikashop/8015-more-products-by-this-artist#8234 "Hi Nicholas, I'm trying to show three more products from an artist on the product detail page. I thought it worked well, until I found out that when an artist doesn't have three products, some other products not from the same artist are shown. Am I doing something wrong or is this a bug. Please see the definition attached. Gert.")* Yes I did that. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwMTUtbW9yZS1wcm9kdWN0cy1ieS10aGlzLWFydGlzdD90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86322 - Thank you received: 14281 - - 15 years 8 months ago [\#8236](#8236) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: More Products by this artist](/forum/2-general-talk-about-hikashop/8015-more-products-by-this-artist#8236 "Hi Nicholas, I'm trying to show three more products from an artist on the product detail page. I thought it worked well, until I found out that when an artist doesn't have three products, some other products not from the same artist are shown. Am I doing something wrong or is this a bug. Please see the definition attached. Gert.")* Could you give a link to your store so that we can have a look ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwMTUtbW9yZS1wcm9kdWN0cy1ieS10aGlzLWFydGlzdD90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[YakNarak](/forum/user/476-yaknarak "View YakNarak's Profile")** - [![YakNarak's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/476-yaknarak "View YakNarak's Profile") Topic Author - [ Offline](/forum/user/476-yaknarak) Less More - Posts: 86 - Thank you received: 0 - - 15 years 8 months ago [\#8751](#8751) by [YakNarak](/forum/user/476-yaknarak "View YakNarak's Profile") Replied by *[YakNarak](/forum/user/476-yaknarak "View YakNarak's Profile")* on topic *[Re: More Products by this artist](/forum/2-general-talk-about-hikashop/8015-more-products-by-this-artist#8751 "Hi Nicholas, I'm trying to show three more products from an artist on the product detail page. I thought it worked well, until I found out that when an artist doesn't have three products, some other products not from the same artist are shown. Am I doing something wrong or is this a bug. Please see the definition attached. Gert.")* Sorry, was in Birma for a couple of days without any internet access. I PM you the login details. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwMTUtbW9yZS1wcm9kdWN0cy1ieS10aGlzLWFydGlzdD90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86322 - Thank you received: 14281 - - 15 years 8 months ago [\#8760](#8760) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: More Products by this artist](/forum/2-general-talk-about-hikashop/8015-more-products-by-this-artist#8760 "Hi Nicholas, I'm trying to show three more products from an artist on the product detail page. I thought it worked well, until I found out that when an artist doesn't have three products, some other products not from the same artist are shown. Am I doing something wrong or is this a bug. Please see the definition attached. Gert.")* Could you give an example of a page where it doesn't work like you want ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwMTUtbW9yZS1wcm9kdWN0cy1ieS10aGlzLWFydGlzdD90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[YakNarak](/forum/user/476-yaknarak "View YakNarak's Profile")** - [![YakNarak's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/476-yaknarak "View YakNarak's Profile") Topic Author - [ Offline](/forum/user/476-yaknarak) Less More - Posts: 86 - Thank you received: 0 - - 15 years 8 months ago [\#8768](#8768) by [YakNarak](/forum/user/476-yaknarak "View YakNarak's Profile") Replied by *[YakNarak](/forum/user/476-yaknarak "View YakNarak's Profile")* on topic *[Re: More Products by this artist](/forum/2-general-talk-about-hikashop/8015-more-products-by-this-artist#8768 "Hi Nicholas, I'm trying to show three more products from an artist on the product detail page. I thought it worked well, until I found out that when an artist doesn't have three products, some other products not from the same artist are shown. Am I doing something wrong or is this a bug. Please see the definition attached. Gert.")* Did you change anything? The page that always showed wrong is now ok!? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwMTUtbW9yZS1wcm9kdWN0cy1ieS10aGlzLWFydGlzdD90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86322 - Thank you received: 14281 - - 15 years 8 months ago [\#8769](#8769) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: More Products by this artist](/forum/2-general-talk-about-hikashop/8015-more-products-by-this-artist#8769 "Hi Nicholas, I'm trying to show three more products from an artist on the product detail page. I thought it worked well, until I found out that when an artist doesn't have three products, some other products not from the same artist are shown. Am I doing something wrong or is this a bug. Please see the definition attached. Gert.")* I didn't change anything yet as I couldn't find anything wrong ![:p](/media/kunena/emoticons/14.png ":p") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwMTUtbW9yZS1wcm9kdWN0cy1ieS10aGlzLWFydGlzdD90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[YakNarak](/forum/user/476-yaknarak "View YakNarak's Profile")** - [![YakNarak's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/476-yaknarak "View YakNarak's Profile") Topic Author - [ Offline](/forum/user/476-yaknarak) Less More - Posts: 86 - Thank you received: 0 - - 15 years 8 months ago [\#8771](#8771) by [YakNarak](/forum/user/476-yaknarak "View YakNarak's Profile") Replied by *[YakNarak](/forum/user/476-yaknarak "View YakNarak's Profile")* on topic *[Re: More Products by this artist](/forum/2-general-talk-about-hikashop/8015-more-products-by-this-artist#8771 "Hi Nicholas, I'm trying to show three more products from an artist on the product detail page. I thought it worked well, until I found out that when an artist doesn't have three products, some other products not from the same artist are shown. Am I doing something wrong or is this a bug. Please see the definition attached. Gert.")* Hmm, Then it probably has something to do with the fact that I installed the latest version last Thursday. Didn't check it after that any more. Anyway, will let you know if I find the problem somewhere else. Thanks. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwMTUtbW9yZS1wcm9kdWN0cy1ieS10aGlzLWFydGlzdD90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[YakNarak](/forum/user/476-yaknarak "View YakNarak's Profile")** - [![YakNarak's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/476-yaknarak "View YakNarak's Profile") Topic Author - [ Offline](/forum/user/476-yaknarak) Less More - Posts: 86 - Thank you received: 0 - - 15 years 8 months ago [\#8785](#8785) by [YakNarak](/forum/user/476-yaknarak "View YakNarak's Profile") Replied by *[YakNarak](/forum/user/476-yaknarak "View YakNarak's Profile")* on topic *[Re: More Products by this artist](/forum/2-general-talk-about-hikashop/8015-more-products-by-this-artist#8785 "Hi Nicholas, I'm trying to show three more products from an artist on the product detail page. I thought it worked well, until I found out that when an artist doesn't have three products, some other products not from the same artist are shown. Am I doing something wrong or is this a bug. Please see the definition attached. Gert.")* Nicolas, The problem is still there. Look at this page: [ www.thaihandmadecraft.com/cms/index.php?...y\_pathway=29&lang=en](http://www.thaihandmadecraft.com/cms/index.php?option=com_hikashop&ctrl=product&task=show&cid=33&name=ceramic-vaselbr-g-golden-flowers&Itemid=23&category_pathway=29&lang=en) You will see that there are products shown from other artists. Gert. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwMTUtbW9yZS1wcm9kdWN0cy1ieS10aGlzLWFydGlzdD90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86322 - Thank you received: 14281 - - 15 years 8 months ago [\#8862](#8862) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: More Products by this artist](/forum/2-general-talk-about-hikashop/8015-more-products-by-this-artist#8862 "Hi Nicholas, I'm trying to show three more products from an artist on the product detail page. I thought it worked well, until I found out that when an artist doesn't have three products, some other products not from the same artist are shown. Am I doing something wrong or is this a bug. Please see the definition attached. Gert.")* Well, your product has two categories, so the module displays the products in the same categories. It's normal. Now I understand that you would like to see only the products of the category from which the user is coming. In order to do that, you will have to edit the file components/com_hikashop/views/product/view.html.php and change the code: $query = "SELECT category_id FROM ".hikashop::table('product_category').' WHERE product_id='.$product_id.' ORDER BY ordering'; $database->setQuery($query); $pageInfo->filter->cid = $database->loadResultArray(); to the code: $pathway = JRequest::getInt('category_pathway',0); if(empty($pathway)){ //load products in the same categories $query = "SELECT category_id FROM ".hikashop::table('product_category').' WHERE product_id='.$product_id.' ORDER BY ordering'; $database->setQuery($query); $pageInfo->filter->cid = $database->loadResultArray(); }else{ $pageInfo->filter->cid = array($pathway); } Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwMTUtbW9yZS1wcm9kdWN0cy1ieS10aGlzLWFydGlzdD90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[YakNarak](/forum/user/476-yaknarak "View YakNarak's Profile")** - [![YakNarak's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/476-yaknarak "View YakNarak's Profile") Topic Author - [ Offline](/forum/user/476-yaknarak) Less More - Posts: 86 - Thank you received: 0 - - 15 years 8 months ago [\#8875](#8875) by [YakNarak](/forum/user/476-yaknarak "View YakNarak's Profile") Replied by *[YakNarak](/forum/user/476-yaknarak "View YakNarak's Profile")* on topic *[Re: More Products by this artist](/forum/2-general-talk-about-hikashop/8015-more-products-by-this-artist#8875 "Hi Nicholas, I'm trying to show three more products from an artist on the product detail page. I thought it worked well, until I found out that when an artist doesn't have three products, some other products not from the same artist are shown. Am I doing something wrong or is this a bug. Please see the definition attached. Gert.")* Thanks so much Nicholas, Working fine now! Gert. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwMTUtbW9yZS1wcm9kdWN0cy1ieS10aGlzLWFydGlzdD90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[YakNarak](/forum/user/476-yaknarak "View YakNarak's Profile")** - [![YakNarak's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/476-yaknarak "View YakNarak's Profile") Topic Author - [ Offline](/forum/user/476-yaknarak) Less More - Posts: 86 - Thank you received: 0 - - 15 years 8 months ago [\#9021](#9021) by [YakNarak](/forum/user/476-yaknarak "View YakNarak's Profile") Replied by *[YakNarak](/forum/user/476-yaknarak "View YakNarak's Profile")* on topic *[Re: More Products by this artist](/forum/2-general-talk-about-hikashop/8015-more-products-by-this-artist#9021 "Hi Nicholas, I'm trying to show three more products from an artist on the product detail page. I thought it worked well, until I found out that when an artist doesn't have three products, some other products not from the same artist are shown. Am I doing something wrong or is this a bug. Please see the definition attached. Gert.")* Hi Nicholas, Unfortunately it's still not what I need. Now if I first go to the category artists and then select a product it goes well. But if I start from the category product categories it shows products from the product category, not from the artist. What I need is that whereever I come from, if I display a product page, on that page I only want to see products that were made by the same artist as the product I am showing. Any idea how I can achieve that? Gert. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwMTUtbW9yZS1wcm9kdWN0cy1ieS10aGlzLWFydGlzdD90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86322 - Thank you received: 14281 - - 15 years 8 months ago [\#9035](#9035) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: More Products by this artist](/forum/2-general-talk-about-hikashop/8015-more-products-by-this-artist#9035 "Hi Nicholas, I'm trying to show three more products from an artist on the product detail page. I thought it worked well, until I found out that when an artist doesn't have three products, some other products not from the same artist are shown. Am I doing something wrong or is this a bug. Please see the definition attached. Gert.")* In order to do that, you will have revert the previous change and edit the file components/com_hikashop/views/product/view.html.php and change the code: > $query = "SELECT category\_id FROM ".hikashop::table('product\_category').' WHERE product\_id='.$product\_id.' ORDER BY ordering'; to the code: > //load products in the same first category > $query = "SELECT category\_id FROM ".hikashop::table('product\_category').' WHERE product\_id='.$product\_id.' ORDER BY product\_category\_id ASC LIMIT 1'; And, for all your products, the first category you add to it should be the artist category. If it's always the last, then, you should replace ASC by DESC. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwMTUtbW9yZS1wcm9kdWN0cy1ieS10aGlzLWFydGlzdD90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[YakNarak](/forum/user/476-yaknarak "View YakNarak's Profile")** - [![YakNarak's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/476-yaknarak "View YakNarak's Profile") Topic Author - [ Offline](/forum/user/476-yaknarak) Less More - Posts: 86 - Thank you received: 0 - - 15 years 8 months ago [\#9061](#9061) by [YakNarak](/forum/user/476-yaknarak "View YakNarak's Profile") Replied by *[YakNarak](/forum/user/476-yaknarak "View YakNarak's Profile")* on topic *[Re: More Products by this artist](/forum/2-general-talk-about-hikashop/8015-more-products-by-this-artist#9061 "Hi Nicholas, I'm trying to show three more products from an artist on the product detail page. I thought it worked well, until I found out that when an artist doesn't have three products, some other products not from the same artist are shown. Am I doing something wrong or is this a bug. Please see the definition attached. Gert.")* Hi Nicolas, Followed your recommendations but still the same problem. Changed your code to DESC because the artist is the second category. But it doesn't change anything. Gert. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwMTUtbW9yZS1wcm9kdWN0cy1ieS10aGlzLWFydGlzdD90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86322 - Thank you received: 14281 - - 15 years 8 months ago [\#9064](#9064) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: More Products by this artist](/forum/2-general-talk-about-hikashop/8015-more-products-by-this-artist#9064 "Hi Nicholas, I'm trying to show three more products from an artist on the product detail page. I thought it worked well, until I found out that when an artist doesn't have three products, some other products not from the same artist are shown. Am I doing something wrong or is this a bug. Please see the definition attached. Gert.")* Could you paste the code around your modifications ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwMTUtbW9yZS1wcm9kdWN0cy1ieS10aGlzLWFydGlzdD90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[YakNarak](/forum/user/476-yaknarak "View YakNarak's Profile")** - [![YakNarak's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/476-yaknarak "View YakNarak's Profile") Topic Author - [ Offline](/forum/user/476-yaknarak) Less More - Posts: 86 - Thank you received: 0 - - 15 years 8 months ago [\#9130](#9130) by [YakNarak](/forum/user/476-yaknarak "View YakNarak's Profile") Replied by *[YakNarak](/forum/user/476-yaknarak "View YakNarak's Profile")* on topic *[Re: More Products by this artist](/forum/2-general-talk-about-hikashop/8015-more-products-by-this-artist#9130 "Hi Nicholas, I'm trying to show three more products from an artist on the product detail page. I thought it worked well, until I found out that when an artist doesn't have three products, some other products not from the same artist are shown. Am I doing something wrong or is this a bug. Please see the definition attached. Gert.")* Hi Nicolas, Not sure what you mean. What would you like to see? By the way, you can still login to the site if it helps. Gert. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwMTUtbW9yZS1wcm9kdWN0cy1ieS10aGlzLWFydGlzdD90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[YakNarak](/forum/user/476-yaknarak "View YakNarak's Profile")** - [![YakNarak's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/476-yaknarak "View YakNarak's Profile") Topic Author - [ Offline](/forum/user/476-yaknarak) Less More - Posts: 86 - Thank you received: 0 - - 15 years 8 months ago [\#9132](#9132) by [YakNarak](/forum/user/476-yaknarak "View YakNarak's Profile") Replied by *[YakNarak](/forum/user/476-yaknarak "View YakNarak's Profile")* on topic *[Re: More Products by this artist](/forum/2-general-talk-about-hikashop/8015-more-products-by-this-artist#9132 "Hi Nicholas, I'm trying to show three more products from an artist on the product detail page. I thought it worked well, until I found out that when an artist doesn't have three products, some other products not from the same artist are shown. Am I doing something wrong or is this a bug. Please see the definition attached. Gert.")* Nicolas, Solved the issue already. It was a problem in the database, not in the code. Gert. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwMTUtbW9yZS1wcm9kdWN0cy1ieS10aGlzLWFydGlzdD90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[YakNarak](/forum/user/476-yaknarak "View YakNarak's Profile")** - [![YakNarak's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/476-yaknarak "View YakNarak's Profile") Topic Author - [ Offline](/forum/user/476-yaknarak) Less More - Posts: 86 - Thank you received: 0 - - 15 years 2 months ago [\#24854](#24854) by [YakNarak](/forum/user/476-yaknarak "View YakNarak's Profile") Replied by *[YakNarak](/forum/user/476-yaknarak "View YakNarak's Profile")* on topic *[Re: More Products by this artist](/forum/2-general-talk-about-hikashop/8015-more-products-by-this-artist#24854 "Hi Nicholas, I'm trying to show three more products from an artist on the product detail page. I thought it worked well, until I found out that when an artist doesn't have three products, some other products not from the same artist are shown. Am I doing something wrong or is this a bug. Please see the definition attached. Gert.")* Nicholas, After working almost 6 months with the system I still have a problem with the above. The problem is that if an artist has a lower id than the product category it always comes in the first place, even if i add it after the product category. The ASC, DESC part is therefor not working. Any other way this can be solved? Gert. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwMTUtbW9yZS1wcm9kdWN0cy1ieS10aGlzLWFydGlzdD90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86322 - Thank you received: 14281 - - 15 years 2 months ago [\#24856](#24856) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: More Products by this artist](/forum/2-general-talk-about-hikashop/8015-more-products-by-this-artist#24856 "Hi Nicholas, I'm trying to show three more products from an artist on the product detail page. I thought it worked well, until I found out that when an artist doesn't have three products, some other products not from the same artist are shown. Am I doing something wrong or is this a bug. Please see the definition attached. Gert.")* Are you sure that you're using the code ORDER BY product_category_id ASC and not ORDER BY category_id ASC ? Because product_category_id will order the categories with the first one being the first added in the categories of the product while category_id will order the categories with the first one being the first category created, which is what you're describing. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwMTUtbW9yZS1wcm9kdWN0cy1ieS10aGlzLWFydGlzdD90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.212 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)