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</Div> 2009-02-02=><Div id=''1''style=''color:red''>yyyyy</Div><Div id=''2''style=''color:green''>xxxxx</Div> 2009-02-03=><Div id=''1''style=''color:red''>yyyyy</Div><Div id=''2''style=''color:green''>xxxxx</Div> 2009-02-04=><Div id=''1''style=''color:red''>yyyyy</Div><Div id=''2''style=''color:green''>xxxxx</Div> 2009-02-05=><Div id=''1''style=''color:red''>yyyyy</Div><Div id=''2''style=''color:green''>xxxxx</Div> 2009-02-06=><Div id=''1''style=''color:red''>yyyyy</Div><Div id=''2''style=''color:green''>xxxxx</Div> 2009-02-07=><Div id=''1''style=''color:red''>yyyyy</Div><Div id=''2''style=''color:green''>xxxxx</Div> 2009-02-08=><Div id=''1''style=''color:red''>yyyyy</Div><Div id=''2''style=''color:green''>xxxxx</Div> 2009-02-09=><Div id=''1''style=''color:red''>yyyyy</Div><Div id=''2''style=''color:green''>xxxxx</Div> 2009-02-10=><Div id=''1''style=''color:red''>yyyyy</Div><Div id=''2''style=''color:green''>xxxxx</Div> 2009-02-11=><Div id=''1''style=''color:red''>yyyyy</Div><Div id=''2''style=''color:green''>xxxxx</Div> 2009-02-12=><Div id=''1''style=''color:red''>yyyyy</Div><Div id=''2''style=''color:green''>xxxxx</Div> 2009-02-13=><Div id=''1''style=''color:red''>yyyyy</Div><Div id=''2''style=''color:green''>xxxxx</Div> 2009-02-14=><Div id=''1''style=''color:red''>yyyyy</Div><Div id=''2''style=''color:green''>xxxxx</Div> 2009-02-15=><Div id=''1''style=''color:red''>yyyyy</Div> 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. -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---