alias test {

  var %db = mirc
  var %address = localhost
  var %username = username
  var %password = password

  var %con = $mysql_connect(%address, %username, %password)

  if (%con) {
    if (!$mysql_select_db(%con, %db)) {
      echo 4 Unable to select database: %db
    }

    var %sql = SELECT * FROM test WHERE id = 1
    var %req = $mysql_query(%con, %sql)

    if ($mysql_num_rows(%req) > 0) {
      echo 4 Results: $mysql_num_rows(%req)

      $mysql_fetch_row(%req, row);

      msg $active Username: $hget(row, username) $+ , Password: $hget(row, password)
    }

  }

}