Featured Product Duplicates

I was trying to do something with the featured products that show up on the homepage.

But whatever i did, didn't work and when i revered back to my old SQL query, i must have done something wrong because i get my products duplicating.

Its pulling the same product for every category it was assigned to.

Any ideas?

you can see it here:

https://www.shopcentralsports.com/shop/pc/home.asp

You'll see the same blue sneaker is showing up three times.

i edited home.ap around line 153 for the query.

the strange thing is that even after i found an old backup and copied old code out of it  - it didn't restore it ... :-(

if anyone has an idea - or backup clean code for Home.asp please let me kow - i'm at my wits end.

Thanks

Smacks of an INNER JOIN issue in the query you edited.

Greg sent you the original query with recommendation to request original home.asp file. That's definitely in order.

Once you recover, mind sharing with us what you were looking to accomplish? Let us know, and I'm sure we'll be able to help with advice that won't blow up your results. Search Queries using INNER JOINS are rather notorious for throwing duplicate results just as you got. It's not so simple to just add another element to the query (which is what I suspect you attempted). Let us know what you are trying to do and one of us here will surely pipe in with a recommended query for you to use.

 

 

The CSS work that we completed there would be directly applicable to your project, just a different triggering mechanism.

Greg - if i can't figure it out i will def get in touch with you. 

A general update, i was able to get back the original query fully functioning. So Thank you everyone for your help!