Add sort price description

  • Posts: 81509
  • Thank you received: 13064
  • MODERATOR
3 years 5 months 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: 173
  • Thank you received: 14
  • Hikashop Business
3 years 5 months 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.057 seconds
Powered by Kunena Forum