You use the CONTENT cObject in order to have TYPO3 output content from the database. You will have to enter a few additional statements so that this object knows which table to get the contents from. By default, the page content from the tt_content table is stored. Use the table property of the CONTENT object to access it. An example:
page.10.marks.RIGHT= CONTENT
page.10.marks.RIGHT {
table = tt_content
}
It is possible to loop through records with the CONTENT object. That way, all of the records that are defined within the current page are output. The only exceptions would be hidden pages or pages that don't allow access rights.
Content can also be read out directly from the database by the use of CONTENT objects. TYPO3 uses a complex SQL query for this, which looks like this when simplified:
SELECT * FROM [.table] WHERE pid = [PID]
You can now use TypoScript to execute this SQL query. It is an advantage if you have SQL experience, but you...