Linda,

I checked the MySql tables using the CHECK TABLE tablename
function and there do not seem to be any tables that are corrupt.
I believe that the CHECK TABLE function looks at the keys for
each table to ensure that links to other tables are not broken, as
well as other checks.

This is really puzzling. As the sort by price works in the admin I have to assume (maybe a BAD IDEA) that the DB is okay.
That leaves me with trying to find out what PHP code might be
causing the problem.

As I stated earlier, I made all of the code changes as outlined
in the link you sent

http://www.zen-cart.com/forum/showthread.php?t=82619

so unless I goofed when making the code updates then there is
still something not quite right. I am going to keep after this until
I find the solution.

Thanks again for you help. I will let you know when I find the
problem.

John