Skip to main content

Add sort price description

More
5 years 10 months ago #325207 by nicolas
Replied by nicolas on topic Add sort price description
Hi,

You need to use the round function of MySQL :
www.w3schools.com/sql/func_mysql_round.asp
So instead of:
concat(product.product_description,'$',product.product_sort_price)
you could use:
concat(product.product_description,'$',round(product.product_sort_price,2))

Please Log in or Create an account to join the conversation.

More
5 years 10 months ago #325254 by smithshop123
That worked perfectly! I'd count this as solved for us.

Thanks,
Ian and Stu
The following user(s) said Thank You: nicolas

Please Log in or Create an account to join the conversation.

Time to create page: 0.188 seconds
Powered by Kunena Forum