wqe Select CustomerID,SalesID,CustomerName,Num_Of_Bottles,Price,Status from sales,customer where Date = DATE_FORMAT(NOW(),'%b %d, %Y') and CustomerID>0 Order by SalesID DESC

why is it duplicating? this is the real result in table but in query it duplicated 150230

from sales,customer

You are selecting from two tables without a join. That causes such behaviour.

Hard to say, depends on the information you have and need. You'll need to provide your table structure, sample data and sample output.