I have an existing wpDataTables table with 203 records in it and about 8 columns.  We do not want to output the results of the table using the traditional table format.  Ideally we would want something like so

[foreach row]

<div>
<h3>[column1]</h3>
<h4>[column2]</h4>
<p>[column4]</p>
</div>

[/foreach]

Is there a way to accomplish this?

Thank you!!!!

Hi Adam,

I had the same problem. This is my workaround;

SELECT 
    concat('Item id:  ','<br/>','Item Number: ','<br/>','Item description: ') as "Labels", (<= these are textstrings)
    concat(`Item_ID`,'<br/>',`Item_Name`,'<br/>',`Item_description`)) as "Values" (<= these are Tablevalues)
FROM TblItems

And if you don't want the labels...

SELECT concat(`Item_ID`,'<br/>',`Item_Name`,'<br/>',`Item_description`)) as "Values"  FROM TblItems

I hope, this might help you!

Tim