Select weeks from last year

[hotliquer]

Hi i am trying to select weeks from the whole of last year and then total all the info in each week and print out weekly sales stats.

unfortunatly my crappy script is showing me every week from today to exactly a year from now and not doing any calculations either!!

any one got any iideas??

$date = 2005-01-01;
$x = 0;
while ($x < 53) {
$yesterdays_takings = mysql_query ("SELECT * FROM arcade_takings WHERE date = '$date'");

   while($row = @mysql_fetch_array($yesterdays_takings))
   $cash = ( $row[cash]);
   $chq = ( $row[chq]);
   $card = ( $row[card]);
   $total = ($total + $card + $cash + $chq);
   $yesterday  = date("l d F Y", strtotime("$x week"));
   print ("<tr><td>$yesterday</td><td>£$total</td></tr>");  
    $x++;[/QUOTE]

thanks a bunch

Ben

[devinemke]

SELECT WEEK(date) AS week, SUM(cash + chq + card) AS sum FROM arcade_takings WHERE YEAR(date) = '2005' GROUP BY week

[hotliquer]

Thanks but does the below code mean i do not need any of the code i originally posted??

devinemke wrote:

SELECT WEEK(date) AS week, SUM(cash + chq + card) AS sum FROM arcade_takings WHERE YEAR(date) = '2005' GROUP BY week

[devinemke]

hotliquer wrote:

Thanks but does the below code mean i do not need any of the code i originally posted??

did you run the query i posted?

[hotliquer]

devinemke wrote:

did you run the query i posted?

Yes . it printed out from todays date. i really need to know the php to go with it.

[hotliquer]

Hey i have completely wiped my script to use just your the query. and hey presto. damn! i cant believe how small the the script is now!!! i have such a long way to go!

thankyou dearly for your time devinemke