Values should be filled for corresponding date, in a range

Hi ,

I'm newbie to Rails can someone help in this.I had struck here in my

application and actually i solved it using PHP but don’t know how to do
in Rails.
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.

On Wed, Feb 4, 2009 at 9:31 PM, Shankar G. <
[email protected]> wrote:

|1 | test |2009-02-01 | red |2009-02-15 | yyyyy |
2009-02-03=><Div id='1’style=‘color:red’>yyyyy
<Div id='2’style=‘color:green’>xxxxx
2009-02-14=><Div id='1’style=‘color:red’>yyyyy
How about something like:
<% @records.each do |record| %>
<%= h record.when %>
<%= tag(“div”, { :id => record.id, :style => “color:#{record.color}”
})
<% end %>

–wpd