HI,
We have a table that looks like the following:
id,username,password,area,order_id
1,joe,88,5,100
2,joex,99,5,102
3,joey,77,5,NONE
4,jane,66,4,101
5,janey,22,4,NONE
What we want to do is have the results displayed as
Area, Available, Issued
5 1 2
4 1 1...