# Showing similar values in a table

**URL:** <https://www.ruby-forum.com/t/showing-similar-values-in-a-table/99476>\
**Category:** Ruby\
**Created:** [July 23, 2006, 7:22am UTC](https://www.ruby-forum.com/t/showing-similar-values-in-a-table/99476 "2006-07-23T07:22:14Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![raffir](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/2acd7d/32.png) [@raffir](https://www.ruby-forum.com/u/raffir)\
**Post date:** [July 23, 2006, 7:22am UTC](https://www.ruby-forum.com/t/showing-similar-values-in-a-table/99476/1 "2006-07-23T07:22:14Z")

</div>

I’m working on a project in which Accounts belong to a User.

I’d like the User’s Welcome page to show who else has the same Accounts  
(based on account name) as that user.

What I tried to do was place a SQL query inside a for loop, such that  
the loop would go through the session User’s accounts and check, in  
turn, for all similarly named accounts in the Accounts table.

I think that there must be something wrong with my code; right now,  
it’s as follows:

```
<table>
<%@session['user'].accounts.each do |i| %>
<%Accounts.find(:all, conditions = ["coursename LIKE ?",

```

“%#{i.coursename}%”])%\>

  
\<%= account.name %\>  
\<%= account.number %\>  
\<%= account.user\_id%\>  
  
  
\<%end%\>

```
<% end %>

```

I’m new to Ruby, so I think syntax is the most likely culprit here.

Thoughts?

Thanks a lot,

- Raffi.

---

<div class="post-metadata">

**Author:** ![raffir](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/2acd7d/32.png) [@raffir](https://www.ruby-forum.com/u/raffir)\
**Post date:** [July 23, 2006, 11:46am UTC](https://www.ruby-forum.com/t/showing-similar-values-in-a-table/99476/2 "2006-07-23T11:46:12Z")

</div>

Hi,

On 7/23/06, removed\_email\_address@domain.invalid [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> I’m working on a project in which Accounts belong to a User.
> 
>   
> \<%@session[‘user’].accounts.each do |i| %\>  
> \<%Accounts.find(:all, conditions = [“coursename LIKE ?”,  
> “%#{i.coursename}%”])%\>
> 
> You’re missing second ‘each’ here  
> \<%Accounts.find(:all, conditions = [“coursename LIKE ?”,  
> “%#{i.coursename}%”]).each do |account| %\>

---

<div class="post-metadata">

**Author:** ![raffir](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/2acd7d/32.png) [@raffir](https://www.ruby-forum.com/u/raffir)\
**Post date:** [July 23, 2006, 5:37pm UTC](https://www.ruby-forum.com/t/showing-similar-values-in-a-table/99476/3 "2006-07-23T17:37:02Z")

</div>

Unfortunately, while it’s now showing accounts, it’s now showing every  
single account. I’d just like it to show accounts with the same name as  
the session user’s.

Thanks,

```
- Raffi.
```

---

<div class="post-metadata">

**Author:** ![raffir](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/2acd7d/32.png) [@raffir](https://www.ruby-forum.com/u/raffir)\
**Post date:** [July 23, 2006, 5:55pm UTC](https://www.ruby-forum.com/t/showing-similar-values-in-a-table/99476/4 "2006-07-23T17:55:56Z")

</div>

Fixed it!

The line was missing a colon. I changed it to:

\<%Accounts.find(:all, :conditions =\> [“coursename LIKE ?”,  
“%#{i.coursename}%”]).each do |account| %\>

A question about the SQL query: how do I add another clause? For  
example, what if I’d like to search by coursename (as above) and  
coursenumber?

Thanks,

- Raffi.

---

<div class="post-metadata">

**Author:** ![raffir](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/2acd7d/32.png) [@raffir](https://www.ruby-forum.com/u/raffir)\
**Post date:** [July 23, 2006, 9:38pm UTC](https://www.ruby-forum.com/t/showing-similar-values-in-a-table/99476/5 "2006-07-23T21:38:08Z")

</div>

Mysteriously stopped working again.

Code is as follows:

```
<h3><u>Who's in my courses?</u></h3>
<table>
<%@session['user'].accounts.each do |i| %>
<%Accounts.find(:all, :conditions => ["coursename LIKE ?",

```

“%#{i.coursename}%”]).each do |account| %\>

```
        <tr>
        <td><%= account.coursename %></td>
        <td><%= account.coursenumber %></td>
		<td><%= account.first_name%> <%= account.last_name%></td>
		<td><%= link_to 'Show', :controller=>'user', :action=>'userdetails',

```

:id=\> account.user\_id %\>

```
        <%end%>
<% end %>

```