Please look at
http://forum.x-cart.com/showthread.php?p=238087 near the bottom. I missed the fact that I edited the products.php file along with the code I posted above.
It is an easy fix and I assure you it works. I just tried it on a fresh installation. There is no need to do an extra sql query.
Regards
Wayne