i need help on udf

if i had a table:

tools year number of purchases
pliers 2000 2
hammer 2000 1
screwdriver 2001 1
pliers 2002 2
screwdriver 2000 3
hammer 2001 4

resulting table:

tools 2000 2001 20002 total(numberofPur)
pliers 2 2 4
hammer 1 4 5
screwdriver 3 1 4

how should i create a udf function so that when i type a particular sql statement the result or the display would be like that of the above diagram/table.....?????? i am having some difficulty with this because it is my first time to use MySQL....tnx...