dear master,
from our query get result like this :
date ------------name------ num1
2008-02-01 ------john ---------100
2008-02-02-------john --------200
2008-02-03 ------john --------300
2008-02-01 ------dave--------400
2008-02-02------dave--------500
2008-02-03------dave--------600
if we wanto chane from row to colum and get result like here
name--------2008-02-01 -------2008-02-02--------2008-02-03
john---------100---------------200-----------------300
dave---------400--------------500-----------------600
how in scrip php
thankyou
