How to use function view in Drupal -

hi guys new drupal bare me :) .

i trying lear how create own module , stuck. created text.module, text.install , text.info . it's basic module inputing text.

so have next scenario iput text in textbox saves table in database can display table in :

now question can , how can use function view in picture "ttt" becomes link can see title , text "ttt" ?

edit :

i figure out need :

in table have 3 columns (test_id, title, text)

now use

$result = db_query("select title,text {text} ");

now how can turn title link . let in row 1 col1 of title stands house. how can turn house link. need sometning

$result= db_query ("select n.title, n.text form {text} n n.title = :title", array (":title" => ???? ))

i think looking for

<?php l(t('link text'), 'about-us', array('attributes' => array('class' => 'about-link'))); ?>

HPH