# Fetching values from Table - Need help

**URL:** <https://www.ruby-forum.com/t/fetching-values-from-table-need-help/159419>\
**Category:** Rails\
**Created:** [February 4, 2009, 12:14pm UTC](https://www.ruby-forum.com/t/fetching-values-from-table-need-help/159419 "2009-02-04T12:14:46Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![lookshankar](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/l/7bcc69/32.png) [@lookshankar](https://www.ruby-forum.com/u/lookshankar)\
**Post date:** [February 4, 2009, 12:14pm UTC](https://www.ruby-forum.com/t/fetching-values-from-table-need-help/159419/1 "2009-02-04T12:14:46Z")

</div>

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.