Search the Community

Hello, Hopefully someone will be able to shed some light on this as I am stumped! Basically I have a website were users enter deals into. I have two tables in my database: One called "users" - This stores user information for example user ID username password etc. Another table called "deals" - This stores deal information. Deal name, deal ID, user ID (which user did the deal), Deal amount, and Date the format for date is (YYYY-MM-DD). I am now trying to display the total amount of deals done by each user for a current week for each day. For example in a 7 day calander type of style: USERS SUNDAY MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY SATURDAY USER 1 £65 £70 £56 £38 £87 £33 £44 USER 2 £65 £70 £56 £38 £87 £33 £44 USER 3 £65 £70 £56 £38 £87 £33 £44 Hopefully this makes sense so far! These are the sql queries i've come up with so far... This selects each deal done in the current week: SELECT u.firstname, d.customername, d.dealamount, d.dealdate FROM deals d, users u WHERE u.uid = d.useriD AND YEARWEEK( dealdate ) = YEARWEEK( CURRENT_DATE ); For example: USER 1 DEAL1 £65 2013-03-15 USER 1 DEAL2 £65 2013-03-16 SELECT SUM( d.dealamount ) , u.firstname FROM deals d, users u WHERE u.uid = d.userid AND YEARWEEK( dealdate ) = YEARWEEK( CURRENT_DATE ) GROUP BY u.firstname USER 1 £130 Can anyone help expand on this so it comes out with current days along the top? Thanks in advanced!