<?xml version="1.0" ?>
 <mosinstall type="module">
  <name>hvamember</name>
  <creationDate>04/12/2007</creationDate>
  <author>canh_nguyen</author>
  <copyright>canh_nguyen@hvaonline</copyright>
  <authorEmail> <a href="mailto:canh_nguyen@hvaonline.net">canh_nguyen@hvaonline.net</a> </authorEmail>
  <authorUrl>www.url.com</authorUrl>
  <version>1.0</version>
  <description>Module display member from hva</description>
  <files>
   <filename module="mod_hvamember">mod_hvamember.php</filename>
  </files>
 </mosinstall>

<?php
//hvamember Module//

defined( '_VALID_MOS' ) or die( 'Direct Access to this location is not allowed.' );

global $database;
$query = "SELECT user FROM hvamember WHERE id='80306'";
$database->setQuery( $query );
$rows = $database->loadObjectList();

echo $row->username;

?>

$query = "SELECT user FROM hvamember WHERE id='80306'";

$query = "SELECT username,password FROM hvamember WHERE color='orange'";
$database->setQuery( $query );
$rows = $database->loadObjectList();

echo $row->username;
echo $row->password;