Change order results in SelectProduct.php

[PakRicard]

Hi all:

Does it make sense to change the order of the results in SelectProduct.php to

ORDER BY stockmaster.discontinued, stockmaster.stockid instead of current ORDER BY stockmaster.stockid?

It will return the current items (not discontinued) results first and then the obsolete (discontinued) ones. Most probably users are searching current items not obsolete ones, so chances are this order will make searches more efficient.

If it's acceptable for the community I'll code it...

[PakRicard]

Coded and commited today.

[phil]

Nice thanks....