Add sort price description

  • Posts: 72763
  • Thank you received: 11096
  • MODERATOR
6 months 1 week ago #325207

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.

  • Posts: 129
  • Thank you received: 11
  • Hikashop Business
6 months 1 week ago #325254

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.058 seconds
Powered by Kunena Forum