<?php
require_once('../config/config.php');
require_once(CLASS_DIR.'dbClass.php');
$obj = new DBClass();
$cupage = 'user';

$sql = "SELECT * FROM ".TBL_USER." WHERE id = '".$_GET['id']."'";
$rs = $obj->executeQry($sql,$link);
$row = $obj->fetchrow();

$dat = explode('-', $row['register_date']);
$dat = $dat[1].'-'.$dat[2].'-'.$dat[0];
?>
<table width="1000" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td height="17"></td>
  </tr>
  <tr>
    <td><table width="910" border="0" align="center" cellpadding="0" cellspacing="0">
      <tr>
        <td class="pagehead"><table width="900" border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td width="315" height="35">View User Details</td>
            </tr>
        </table></td>
      </tr>
      <tr>
        <td valign="top" bgcolor="#FFFFFF" class="innermain"><table width="800" border="0" align="center" cellpadding="0" cellspacing="0">
          <tr>
            <td height="25">&nbsp;</td>
          </tr>
          <tr>
            <td valign="top" class="bdr4"><table width="800" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td bgcolor="#990066" class="form_head">Name & Address</td>
                </tr>
              <tr>
                <td valign="top" class="form_bg"><table width="500" border="0" cellpadding="0" cellspacing="0" class="form_txt1">
                  <tr>
                    <td align="left" width="90">Name</td>
			<td align="center" width="5">:</td>
                    <td><? echo $row['fname'].' '.$row['lname'];?></td>
                    </tr>
                  <tr>
                    <td>Company name</td>
			<td>:</td>
                    <td><? echo $row['company_name'];?></td>
                    </tr>
                  <tr>
                    <td>CRN#</td>
			<td>:</td>
                    <td><? echo $row['crn']; ?></td>
                    </tr>
                  <tr>
                    <td>Address: </td>
			<td>:</td>
                    <td><? echo $row['address1'];?></td>
                    </tr>
                  <tr>
                    <td>City: </td>
			<td>:</td>
                    <td><? echo $row['city'];?></td>
                    </tr>
                  <tr>
                    <td>State: </td>
			<td>:</td>
                    <td><? echo $row['state'];?></td>
                    </tr>
                    <tr>
                    <td>Country: </td>
			<td>:</td>
                    <td><? echo $row['country'];?></td>
                    </tr>
                  <tr>
                    <td>Zip: </td>
			<td>:</td>
                    <td><? echo $row['zip'];?></td>
                    </tr>
                  </table></td>
              </tr>
              <tr>
                <td bgcolor="#990066" class="form_head">Contact Details</td>
              </tr>
              <tr>
                <td valign="top" class="form_bg"><table width="500" border="0" cellpadding="0" cellspacing="0" class="form_txt1">
                  <tr>
                    <td align="left" width="90">Email</td>
                    <td align="center" width="5">:</td>
                    <td align="left"><? echo $row['email'];?></td>
                    </tr>
                  <tr>
                    <td align="left">Phone</td>
                    <td align="center" width="5">:</td>
			<td align="left"><? echo $row['phone'];?></td>
                  </tr>
                  <tr>
                    <td align="left">Fax</td>
                    <td align="center" width="5">:</td>
			<td align="left"><? echo $row['fax'];?></td>
                  </tr>
                </table></td>
              </tr>
              <tr>
                <td bgcolor="#990066" class="form_head">&nbsp;</td>
              </tr>
              <tr>
                <td align="left" valign="top" class="form_bg"><table width="500" border="0" cellpadding="0" cellspacing="0" class="form_txt1">
                  <tr>
                    <td align="left" width="90">Member Since / Exp. Date</td>
                    <td align="center" width="5">:</td>
                    <td align="left"><? echo $dat;?> / <?=$row['exp_date']?></td>
                    </tr>
                  </table></td>
              </tr>
              </table></td>
          </tr>
          </table></td>
      </tr>
      </table></td>
  </tr>
</table>


