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.