Fetching values from Table - Need help


#1

Hi ,

I have table like this
 ---------------------------------------------------------------
|id | what   | when      | color  |   to      | description     |
---------------------------------------------------------------
|1  | test   |2009-02-01 | red    |2009-02-15 |    yyyyy        |
---------------------------------------------------------------
|2  | test2  |2009-02-02 | green  |2009-02-14 |    xxxxx        |
-----------------------------------------------------------------

i want output like this,

2009-02-01=><Div id='1’style=‘color:red’>yyyyy
2009-02-02=><Div id='1’style=‘color:red’>yyyyy<Div
id='2’style=‘color:green’>xxxxx
2009-02-03=><Div id='1’style=‘color:red’>yyyyy<Div
id='2’style=‘color:green’>xxxxx
2009-02-04=><Div id='1’style=‘color:red’>yyyyy<Div
id='2’style=‘color:green’>xxxxx
2009-02-05=><Div id='1’style=‘color:red’>yyyyy<Div
id='2’style=‘color:green’>xxxxx
2009-02-06=><Div id='1’style=‘color:red’>yyyyy<Div
id='2’style=‘color:green’>xxxxx
2009-02-07=><Div id='1’style=‘color:red’>yyyyy<Div
id='2’style=‘color:green’>xxxxx
2009-02-08=><Div id='1’style=‘color:red’>yyyyy<Div
id='2’style=‘color:green’>xxxxx
2009-02-09=><Div id='1’style=‘color:red’>yyyyy<Div
id='2’style=‘color:green’>xxxxx
2009-02-10=><Div id='1’style=‘color:red’>yyyyy<Div
id='2’style=‘color:green’>xxxxx
2009-02-11=><Div id='1’style=‘color:red’>yyyyy<Div
id='2’style=‘color:green’>xxxxx
2009-02-12=><Div id='1’style=‘color:red’>yyyyy<Div
id='2’style=‘color:green’>xxxxx
2009-02-13=><Div id='1’style=‘color:red’>yyyyy<Div
id='2’style=‘color:green’>xxxxx
2009-02-14=><Div id='1’style=‘color:red’>yyyyy<Div
id='2’style=‘color:green’>xxxxx
2009-02-15=><Div id='1’style=‘color:red’>yyyyy

Note:

The ‘id’ of div is the value of ‘id’ field in database
The ‘color’ of div is the value of ‘color’ field in database
The ‘description’ of div is the value of ‘description’ field in database

can any one help in this for me…
Thanks in advance,
shankar.