fetching the result

[anand perumal]

hello,

Pls help me... Almost in all my projects I have a problem.. That may ba a silly question.. but i need a soultion for this...

I have two tables like patient masters and history masters...


Patient masters

id patient_name
1 Anand
2 Bala
3 Selva


History Masters

id date patient_id
1 2011-5-3 1
2 2011-5-4 1
3 2011-5-6 2
4 2011-6-5- 1
5 2011-7-7 2
6 2011-8-8 3
7 2011-8-8 2


I need to join two tables and want to get result like the following

Name Days
2011-5-3
Anand 2011-5-4
2011-6-5

2011-5-6
Bala 2011-7-7
2011-8-8

Selva 2011-8-8


I mean i m always getting a result in an array.. I want to get the result with array and inner array....

$result =array('id'=>1,'Name'=>'Anand','history'=>array('1'=>'2011-5-3','2'=>'2011-5-4','3'=>'2011-6-5'))

I m using PHP

pls help me...

Thanks
-Anand