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 ?
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 ?