How to display fields of custom table

I have my own table in the database and need to show the data on the page. what are the options?

  1. Query loop is great but as i see it works with post type only, not custom table in the database.
  2. i can use custom php code to connect to database and get the data from the table and then return the data in a function. then i can use {echo:function} in basic text and display one field. but then for another field i need another {echo:function}. it will reduce the speed bcus each time we call {echo:function} it runs the query again!
    We normally run a query once in php and put the result in an array and use that array to display the data. is there any similar way in Bricks?

is “Parse dynamic data” what I need? i didn’t find any tutorials about that:

1 Like