$query="SELECT Completed, Type, custid, TpOrdNo, CustOrderNo, Date, NetTotal FROM `sales` WHERE Date BETWEEN '$date1' AND '$date2'";
$result = mysql_query($query);
$row =mysql_fetch_row($result);
while($row = mysql_fetch_assoc($result,MYSQL_ASSOC))
{
//dostuff
}