MySQL Query to include sales/specials

[LissaE]

Thanx so much....I will have a look at that file :)

The store will most likely end up with hundreds of products but it is kind of like a consignment store where new ones will be added continually so even if I knew how to do the xml file thing it wouldn't suit lol if I notice it start to slow down I can always return it to the query I have now...thanx again

[LissaE]

Blah...I just can't get this lol I don't know enough about mysql queries and syntax and stuff to get it to show the specials/sales prices so I am going to leave it as is for now...probably just put a blurb that items shown may be on sale and to check out the product to see...thanx anyways lol :)