How Block list links to a page with datas from same database table

Permalink
Suppose a table in database,

col1 col2 col3 col4
a xxxx xxxx xxxx
a yyyy yyyy yyyy
b zzzz zzzz zzzz

the col1 serve as key, and I'd like take the col1 values as titles of links list in a block on the top page, when clicked the link "a" OR the link "b", the next page will show a table with content from db talbe's first two rows for "a" or from third row for "b".

link list:
a
b

when click "a", result on next page
a xxx xxx xxx
a yyy yyy yyy

It seems according to discussions here that a page list block can do this, but I'm not sure how. Could anyone give some hint ?

 

This website stores cookies on your computer. These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media. To find out more about the cookies we use, see our Privacy Policy.