Featured Listing Not displaying on Product Listing Page

cyberfolli:

I changed the code and nothing happened.

Careful. You could be running around in circles here. My suggested 'test' is/was based on the assumption/knowledge that you did already have some featured products active and working, as indicated by the link you gave in one of your earlier posts (#6)

http://www.aurumjewelers.net/index.php?main_page=featured_products

I've just re-checked this link and there are currently no featured products showing, so that being the case, my 'test' will show 'nothing happened'.

cyberfolli:

Isn't it strange that the new products show up and the featured do not.

No. Nothing strange about this at all. The code used is different. There are different settings and options for each, and even the products could be different - in fact there is nothing 'the same' about them. What would be 'strange' if they both always showed up in the same places at the same time.

cyberfolli:

Could the Database not be storing the data as a featured product ?

Could be, but how does this explain the fact that there were featured products showing on the main page this time last week?

I suggest you get back to exactly where you were when you posted message#6 (and verify that featured products ARE showing on the main page - Then (and only then) come back and make the change I suggested.

As I said, you could be just running around in circles at the moment.

Cheers
RodG

cyberfolli:

Also the Specials are working fine. So the Code is functioning.

http://www.aurumjewelers.net/penn-state-jewelry

Specials, featured products & new products all use different code, each with their own settings. Please get the idea that 'if one works the others should' out of your head. It isn't helping you, it isn't helping us.

Cheers
RodG

cyberfolli:

I also double checked the data in the database an there are two records there. i changed the dates to make sure they were featured today.

As of 30 seconds ago http://www.aurumjewelers.net/index.php?main_page=featured_products isn't showing any results.

Cheers
RodG

I will leave the code up ..

Should be one product in the featured products list

http://www.aurumjewelers.net/index.php?main_page=featured_products

here is the subcat that it is in

http://www.aurumjewelers.net/bracelets/trollbeads/silver-flowers-nature

I really appreciate your time on this! thank you

cyberfolli:

I will leave the code up ..

OK, so please revert the the code
/includes/modules/YOUR_TEMPLATE/featured_products.php back to how it was before commenting out the two lines I previously instructed.

Find the line that reads
if ($featured_products_query != '') $featured_products = $db->ExecuteRandomMulti($featured_products_query, MAX_DISPLAY_SEARCH_RESULTS_FEATURED);

(The just above the line that reads '$row = 0;")

In between these two line, add

echo "$featured_products_query" ;
print_r($featured_products);
die ;

Save the file and post a copy of the output that you see from both pages that you just listed.

Note: As before, this is going to make a mess of your site (making it unusable), so do this when the site isn't busy, and revert the changes once you've captured the results.

Cheers
RodG