title: How to use function view in Drupal
body: <p>I am trying to learn how to create my own module and I am stuck. I created text.module, text.install and text.info . It's just a basic module for inputing text. </p>
  
  <p>So now I have the next scenario I input the text in textbox,  it saves to a table in the database i can display it into a table like in this:</p>
  
  <p><a href="http://img33.imageshack.us/img33/5815/textyi.jpg" rel="nofollow noreferrer">http://img33.imageshack.us/img33/5815/textyi.jpg</a></p>
  
  <p>now my question is can you and how can you use function view so that in the picture "ttt" becomes a link so that you can see the title and text "ttt" ? </p>
  
  <p>EDIT : </p>
  
  <p>I figure out something i just need this : </p>
  
  <p>in table I have 3 columns (test_id, title, text)</p>
  
  <p>Now i use </p>
  
  <pre><code>$result = db_query("select title,text from {text} ");
  </code></pre>
  
  <p>now how can I turn title into a link . Let say that in row 1 col1 of title it stands house. How can i turn house into a link. Do i need to do sometning like this </p>
  
  <pre><code>$result= db_query ("select n.title, n.text form {text} n where n.title = :title", array (":title" =&gt; ???? ))
  </code></pre>