[SOLVED] CB Query to return multiple values

Hi There,

I've created a new field "Reviews", then have selected the field type of QUERY. Under Parameters and Query Tab i have added in the following SQL Query.

SELECT Message FROM `#__rbid_rate` WHERE user_rated='[user_id]';

On the Display Tab and Output field, i have selected "single row". This works well, pulls the first row of information from the above database table and column and displays the information. However there are multiple rows of data in that table and column that i want to display that match the user_id, how can i get it to display all the rows in that column that match the user_id? If i select in the Output field to display "multiple rows", it doesn't show any data. If i select "template" then it just shows the one row of data and no more.

Any help would be appreciated.

Thanks.

Set Output to Multiple Rows then for Row substitute in your database column using [column_Message]. You can add any other user substitutions you like in the header, row, and footer as well as any HTML you like.

Thanks that worked perfectly. I used the below to pull the data into a list.

<ul style="list-style-type:square">
<li>[Column_Message]</li>
</ul>