Selecting by date

[robives]

I am trying to access a list of items from a table between to date values.
I have the following to set the dates

$fromdate = mktime(0,0,0,$frommonth,$fromday,$fromyear);
$todate = mktime(0,0,0,$tomonth,$today,$toyear);

then the following query

echo("$fromdate <br> $todate");
$query = "SELECT item_name, mc_gross, completed, 
          COUNT(*) countvalue 
		  FROM ipn_tblsaleshistory 
		  GROUP BY item_name
		  WHERE completed BETWEEN '$fromdate' AND '$todate'
		  ";

I get the following output

1115330400
1118613600
couldn't execute query

any advice would be appreciated
- Rob

[robives]

oops - I see where I have gone wrong

$query = "SELECT item_name, mc_gross, completed, 
          COUNT(*) countvalue 
		  FROM ipn_tblsaleshistory
		  WHERE completed BETWEEN '$fromdate' AND '$todate'
		  GROUP BY item_name
		  ";

GROUP by need to be last - however - I am still having a problem the data set returned is empty, no items are fitting the criteria even though there should be 200 or so returned.