title: How to fetch multiple column from mysql using go lang
body: <p>I am trying to fetch multiple columns in a mysql database using the <strong>go</strong> language. Currently I could modify this script, and it would work perfectly well for just fetching one column, and printing it using the http print function. However, when it fetches two things the script no longer works. I don't have any idea what I need to do to fix it. I know that the sql is fine as I have tested that out in the mysql terminal, and it has given me the expected result that I wanted.  </p>
  
  <pre><code> conn, err := sql.Open("mysql", "user:password@tcp(localhost:3306)/database")
   statement, err := conn.Prepare("select first,second from table") 
   rows, err := statement.Query()
   for rows.Next() {
           var first string
           rows.Scan(&amp;first)
           var second string
           rows.Scan(&amp;second)
           fmt.Fprintf(w, "Title of first is :"+first+"The second is"+second)
   }
   conn.Close()
  </code></pre>