More Products by this artist

Nope, this is the code:


$pathway = JRequest::getInt('category_pathway',0);
if(empty($pathway)){
//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 DESC LIMIT 1';
$database->setQuery($query);
$pageInfo->filter->cid = $database->loadResultArray();
}

Nicholas,

Maybe the problem lies somewhere else. With some products the artists shows beneath the product category even when the id of the artist is 40 and the id of the product category is 42.

However in the same group I have a product where the artist id is 29 and the product category id 42.

From this product I deleted both the artist and the product category and then added the product category first and the artist second. The artist still shows before the product.

Is this normal or is this the cause of the problem.

Gert.

I am adding the categories to the products in the correct order. But the problem is that in some cases, even when I add the artist category after the product category, it still shows the artist as the first category. As I said before, it does this for some products, not all.

I did the following:

1. Delete both categories from the product.
2. Save the product.
3. When I reopen the product the system has added a category product groups.
4. Added the correct product group
5. Save the product
6. Delete the category product groups added by the system in step 3
7. Save the product
8. Add the correct artist category.
9. Save the product.

Now when I reopen the product the artist is still the first category and the product group the second.

Nicholas,

Any idea how to solve this?

Gert.

Yes, I did apply the modification. But I don't think the problem is with the modification.

I think the problem is that for some products I am unable to get the artist as the second category. See my earlier post:


Re: More Products by this artist 3 Days, 5 Hours ago
I did the following:

1. Delete both categories from the product.
2. Save the product.
3. When I reopen the product the system has added a category product groups.
4. Added the correct product group
5. Save the product
6. Delete the category product groups added by the system in step 3
7. Save the product
8. Add the correct artist category.
9. Save the product.

Now when I reopen the product the artist is still the first category and the product group the second.

Nicholas,

I tested it again after your last message and it's working now.

Must have been a browser cache problem. Thanks for your help.

Gert.

Hi Nicholas,

Once more I cheered too early. I still cannot get it to work. I even removed the artist from all products and added them again after saving each product.

Could you please have a look at the site to see what's wrong?

Thanks,

Gert.

Just send to you by email. Thanks!

Hi Nicholas,

Yes. Now it really works. Thanks so much!

Gert.

can you show us a screenshot of your system?