ProductPrice & Product MRP
I got a Products table which contain many columns. Two of which are ProductPrice & ProductMRP
ProductPrice is selling price or discounted rate.
ProductMRP is actual product price.
Lets call a product as 'x'
x ProductPrice is 100 - selling price
x ProductMRP is 200
ProductPrice & ProductMRP are of type: float(12,2)
All products have ProductPrice & not necessarily ProductMRP. So ProductMRP data is stored as 'NULL'
So now if Product 'x' has ProductPrice as well as ProductMRP displays perfect.
But when Product 'y' has only ProductPrice and ProductMRP has no value which is as 'Null' how do we show only ProductPrice & not shown ProductMRP?
Regards