How Do I Randomize New Products On Index Page?

[DK_Scully]

I did, yes. I followed the link, looked at the php code...and was thoroughly confused. I am a php moron...give me good old html any day! This stuff looks like gibberish and gives me a headache! Is it possible to walk me through this in plain English?

[Fez-o Joe]

I am a php moron...

And I too am a php idiot... but if you know html then getting your feet wet with php should be easy. Literally, Linda has the line in the module to find, and the in the lower box, the change to be made.

Just make sure that you backup the module first, then make the change and upload it.

It'll take three minutes.

From post 8:


And if in the future someone else is reading this - there's two files and multiple places to update in /includes/modules/new_products and /sideboxes/whats_new

this is an example in the new_products:

$new_products_query = "select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_name,
p.products_date_added, p.products_price, p.products_type, p.master_categories_id
from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
where p.products_id = pd.products_id
and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
and p.products_status = 1 order by rand()" . $display_limit;

Watch that quotation mark! *chuckle*

"I have faith in your ability to handle the situation." (<--- old manager line)

[DK_Scully]

Okay, I made the change in both places and uploaded them to their respective locations. It worked for the What's New module...but not for the New Products module. (And yes, I was careful not to mess with the ".) Now what??

[Fez-o Joe]

Okay, I made the change in both places and uploaded them to their respective locations. It worked for the What's New module...but not for the New Products module. (And yes, I was careful not to mess with the ".) Now what??

Lines 26 and 48, both? (line number may differ - but there is more than one place to change it)

[DK_Scully]

I figured it out, whoo hoo!! Since I'm using the Alyssa Pink template, I had to modify the Alyssa Pink new_products.php file instead of the original one. Now it's working just the way I wanted it to.

Thank you so much for pointing me in the right direction, I really appreciate it!

[DK_Scully]

Okay, I thought I had it figured out. But now I lost the entire box of New Products on the index page, and I have no idea what I did wrong. Help???

[Fez-o Joe]

Just had a thought and am hoping that someone else jumps in on this...

Now that the products are randomizing fine, I find that the products with the 'no image' icon are popping up and don't really look good - so... is there a 'case' or if { that one might be able to insert and have it skip products with no 'no image' file?

Tag!

[Ajeh]

You could add to the select statements:

                           and p.products_image != ''