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.

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>