Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Advanced search get products listed twice


Andybird

Recommended Posts

Hi all,

 

When using Price from and/or Price to from the advanced search I get all products listed twice in the advanced search result. The number of products found is correct, although I get, of course, two times more Result pages. Also the query takes very long, about 30 seconds…

When using the other search options (Categories, Manufacturers, Date…) the result works fine, every product is listed once.

Any idea?

 

Andybird

Link to comment
Share on other sites

  • 4 weeks later...
No idea, guys? That drive me nuts!

Thanks,

Andybird

 

Dont like your comments, if you think we've no idea why are you asking?

 

you need to add 'distinct' to your query, as in select distinct bla bla from bla bla

Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Link to comment
Share on other sites

Dont like your comments, if you think we've no idea why are you asking?

 

you need to add 'distinct' to your query, as in select distinct bla bla from bla bla

 

that's funny but he made the point.

Link to comment
Share on other sites

If Your product is in moer then one categories this might happen.

 

else You modified the search code.

 

 

 

Satish

Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site.

 

Check My About US For who am I and what My company does.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...