random select

[rkoechel2004]

In my installation I have changed "model" to "SKU" and the first 4 digits of the 7 digit SKU tell which department a product is in. My question is i want to use tep_random_select to show random products from a particular department. How do I do a select where products_sku = 1234???

 

Thanks for any help

Ryan

[FalseDawn]

Is the problem that you don't know how to use tep_random_select, or that you don't know how to retrieve the first 4 characters from a string?

[rkoechel2004]

Is the problem that you don't know how to use tep_random_select, or that you don't know how to retrieve the first 4 characters from a string?

 

 

The first 4 characters only from a string, can I just use 3 asterisk after the first 4 digits I want?

[FalseDawn]

No, if you have the SKU in a variable, you can use substr($sku,0,4) in PHP to retrieve the value, or

 

SUBSTRING(sku_column,1,4) in the MySQL query, depending on how you choose to implement it.

 

"sku_column" is obviously the name of the column holding the sku.