<?php require_once('Connections/admin.php'); ?>
<?php require_once('Connections/admin.php'); ?>
<?php
//initialize the session
if (!isset($_SESSION)) {
  session_start();
}

// ** Logout the current user. **
$logoutAction = $_SERVER['PHP_SELF']."?doLogout=true";
if ((isset($_SERVER['QUERY_STRING'])) && ($_SERVER['QUERY_STRING'] != "")){
  $logoutAction .="&". htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_GET['doLogout'])) &&($_GET['doLogout']=="true")){
  //to fully log out a visitor we need to clear the session varialbles
  $_SESSION['MM_Username'] = NULL;
  $_SESSION['MM_UserGroup'] = NULL;
  $_SESSION['PrevUrl'] = NULL;
  unset($_SESSION['MM_Username']);
  unset($_SESSION['MM_UserGroup']);
  unset($_SESSION['PrevUrl']);
	
  $logoutGoTo = "index.php";
  if ($logoutGoTo) {
    header("Location: $logoutGoTo");
    exit;
  }
}
?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$maxRows_getarticles = 1;
$pageNum_getarticles = 0;
if (isset($_GET['pageNum_getarticles'])) {
  $pageNum_getarticles = $_GET['pageNum_getarticles'];
}
$startRow_getarticles = $pageNum_getarticles * $maxRows_getarticles;

mysql_select_db($database_admin, $admin);
$query_getarticles = "SELECT articles.editorial_name, articles.editorial_title, articles.article_name, articles.abstract, article_branch.article_branch, welcome.more, articles.article_id FROM articles, article_branch, welcome WHERE articles.article_branch_id = article_branch.article_branch_id AND welcome.welcome_id =articles.article_id ORDER BY articles.`time` DESC";
$query_limit_getarticles = sprintf("%s LIMIT %d, %d", $query_getarticles, $startRow_getarticles, $maxRows_getarticles);
$getarticles = mysql_query($query_limit_getarticles, $admin) or die(mysql_error());
$row_getarticles = mysql_fetch_assoc($getarticles);

if (isset($_GET['totalRows_getarticles'])) {
  $totalRows_getarticles = $_GET['totalRows_getarticles'];
} else {
  $all_getarticles = mysql_query($query_getarticles);
  $totalRows_getarticles = mysql_num_rows($all_getarticles);
}
$totalPages_getarticles = ceil($totalRows_getarticles/$maxRows_getarticles)-1;

$maxRows_eventonspot = 1;
$pageNum_eventonspot = 0;
if (isset($_GET['pageNum_eventonspot'])) {
  $pageNum_eventonspot = $_GET['pageNum_eventonspot'];
}
$startRow_eventonspot = $pageNum_eventonspot * $maxRows_eventonspot;

mysql_select_db($database_admin, $admin);
$query_eventonspot = "SELECT eventonspot.eventonspot_id, eventcalender.`date`, eventcalender.event_place, eventcalender.event_name, eventcalender.subject FROM eventonspot, eventcalender WHERE eventcalender.eventcalender_id = eventonspot.eventcalender_id";
$query_limit_eventonspot = sprintf("%s LIMIT %d, %d", $query_eventonspot, $startRow_eventonspot, $maxRows_eventonspot);
$eventonspot = mysql_query($query_limit_eventonspot, $admin) or die(mysql_error());
$row_eventonspot = mysql_fetch_assoc($eventonspot);

if (isset($_GET['totalRows_eventonspot'])) {
  $totalRows_eventonspot = $_GET['totalRows_eventonspot'];
} else {
  $all_eventonspot = mysql_query($query_eventonspot);
  $totalRows_eventonspot = mysql_num_rows($all_eventonspot);
}
$totalPages_eventonspot = ceil($totalRows_eventonspot/$maxRows_eventonspot)-1;
?>
<?php
// *** Validate request to login to this site.
if (!isset($_SESSION)) {
  session_start();
}

$loginFormAction = $_SERVER['PHP_SELF'];
if (isset($_GET['accesscheck'])) {
  $_SESSION['PrevUrl'] = $_GET['accesscheck'];
}

if (isset($_POST['user_name'])) {
  $loginUsername=$_POST['user_name'];
  $password=$_POST['password'];
  $MM_fldUserAuthorization = "";
  $MM_redirectLoginSuccess = "registration/memberpage.php";
  $MM_redirectLoginFailed = "registration/login.php";
  $MM_redirecttoReferrer = false;
  mysql_select_db($database_admin, $admin);
  
  $LoginRS__query=sprintf("SELECT username, password FROM menbers WHERE username=%s AND password=%s",
    GetSQLValueString($loginUsername, "text"), GetSQLValueString($password, "text")); 
   
  $LoginRS = mysql_query($LoginRS__query, $admin) or die(mysql_error());
  $loginFoundUser = mysql_num_rows($LoginRS);
  if ($loginFoundUser) {
     $loginStrGroup = "";
    
    //declare two session variables and assign them
    $_SESSION['MM_Username'] = $loginUsername;
    $_SESSION['MM_UserGroup'] = $loginStrGroup;	      

    if (isset($_SESSION['PrevUrl']) && false) {
      $MM_redirectLoginSuccess = $_SESSION['PrevUrl'];	
    }
    header("Location: " . $MM_redirectLoginSuccess );
  }
  else {
    header("Location: ". $MM_redirectLoginFailed );
  }
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Dentist Guide - Unlimitate Dental Solution</title>
<style type="text/css">
<!--
.a1 {
	font-family: Arial, Helvetica, sans-serif;
	font-size: 10px;
}
.style4 {color: #FFFFFF;
	font-family: Arial, Helvetica, sans-serif;
	font-size: 9px;
}
.style11 {font-family: Arial, Helvetica, sans-serif; font-size: 10px; color: #0F4E89; }
.style22 {font-size: 11px}
.style25 {color: #006699; font-size: 12px; font-weight: bold; }
.style231 {	color: #3B3D3C
}
-->
</style>
</head>

<body>
<map name="Map3" id="Map3">
  <area shape="rect" coords="1,1,421,130" href="registration/memberpage.php" />
</map>
<map name="Map3Map2" id="Map3Map2">
  <area shape="rect" coords="1,-1,421,128" href="registration/memberpage.php" />
</map>
<table width="900" border="0" align="center" cellpadding="0" cellspacing="0" class="a1">
  <tr>
    <td align="center" valign="top"><table width="850" border="0" align="center" cellpadding="0" cellspacing="0">
      <tr></tr>
    </table>
      <map name="Map" id="Map">
        <area shape="rect" coords="4,5,79,29" href="index.php" alt="Home" />
      </map>
      <map name="Map2" id="Map2">
        <area shape="rect" coords="5,5,80,30" href="about_us/about_us.php" alt="About Us" />
      </map>
      <map name="Map6" id="Map6">
        <area shape="rect" coords="13,8,75,28" href="archive/archive.html" alt="Archive" />
      </map>
      <map name="Map7" id="Map7">
        <area shape="rect" coords="9,8,79,30" href="contactus/contactus.html" />
    </map></td>
  </tr>
  <tr>
    <td height="20" align="center" valign="middle" bgcolor="#245B94"><img src="images/dgheader.gif" width="900" height="178" /></td>
  </tr>
  <tr>
    <td height="20" align="center" valign="middle" bgcolor="#245B94"><table width="100%" border="0" cellpadding="0" cellspacing="0">
      <tr>
        <td height="96" align="center" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
          <tr>
            <td height="100%" align="center" valign="top"><table width="900" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td width="50%"><table width="80%" border="0" cellpadding="0" cellspacing="1">
                  <tr>
                    <td width="87" height="34" bgcolor="#245B94"><img src="images/home.gif" alt="Home" width="87" height="34" border="0" usemap="#MapMapMap" /></td>
                    <td width="87" height="34" bgcolor="#245B94"><img src="images/aboutus.gif" alt="About Us" width="87" height="34" border="0" usemap="#Map2MapMap" /></td>
                    <td width="87" height="34" bgcolor="#245B94"><img src="images/companies.gif" alt="Companies" width="87" height="34" border="0" usemap="#Map3MapMap" /></td>
                    <td width="87" height="34" bgcolor="#245B94"><img src="images/products.gif" alt="Products" width="87" height="34" border="0" usemap="#Map4MapMap" /></td>
                    <td width="87" height="34" bgcolor="#245B94"><img src="images/mediakit.gif" width="87" height="34" border="0" usemap="#Map4" /></td>
                    <td width="87" height="34" bgcolor="#245B94"><img src="images/archive.gif" alt="Archive" width="87" height="34" border="0" usemap="#Map6MapMap" /></td>
                    <td width="88" height="34" bgcolor="#245B94"><img src="images/contactus.gif" alt="Contact Us" width="88" height="34" border="0" usemap="#Map8MapMap" /></td>
                  </tr>
                </table>
                  <map name="MapMapMap" id="MapMapMap">
                    <area shape="rect" coords="4,5,79,29" href="http://www.dentistguide.theguidedata.com/index.php" alt="Home" />
                  </map>
                  <map name="Map2MapMap" id="Map2MapMap">
                    <area shape="rect" coords="5,5,80,30" href="http://www.dentistguide.theguidedata.com/about_us/about_us.php" alt="About Us" />
                  </map>
                  <map name="Map6MapMap" id="Map6MapMap">
                    <area shape="rect" coords="13,8,75,28" href="http://www.dentistguide.theguidedata.com/archive/archive.php" alt="Archive" />
                  </map>
                  <map name="Map3MapMap" id="Map3MapMap">
                    <area shape="rect" coords="7,7,80,27" href="http://www.dentistguide.theguidedata.com/company/company.php" alt="Companies" />
                  </map>
                  <map name="Map4MapMap" id="Map4MapMap">
                    <area shape="rect" coords="6,6,79,27" href="http://www.dentistguide.theguidedata.com/product/product.php" alt="Products" />
                  </map>
                  <map name="Map8MapMap" id="Map8MapMap">
                    <area shape="rect" coords="7,6,80,28" href="http://www.dentistguide.theguidedata.com/contact_us/contactus.php" alt="Contact Us" />
                  </map></td>
                <td width="5">&nbsp;</td>
                <td valign="bottom"><form action="http://www.dentistguide.theguidedata.com/company/searchcompanyresult.php" name="form" id="form4">
                  <input name="client_name" type="text" class="style11" id="client_name" size="20" />
                  <input name="insert2" type="submit" class="style11" id="insert5" value="Search Company" />
                </form></td>
                <td width="20">&nbsp;</td>
              </tr>
              <tr>
                <td height="30" valign="top"><img src="images/newheader3.gif" alt="Member Page" width="617" height="30" border="0" usemap="#Map9MapMap" /></td>
                <td width="5" height="30" valign="top">&nbsp;</td>
                <td height="30" valign="middle"><form id="form3" name="form1" action="http://www.dentistguide.theguidedata.com/product/productsearchresult.php">
                  <label for="product_name3"></label>
                  <label for="search3"></label>
                  <input name="product_name" type="text" class="style11" id="product_name3" size="20" />
                  <input name="search2" type="submit" class="style11" id="search3" value="  Search Product " />
                </form></td>
                <td width="20" height="30" valign="top">&nbsp;</td>
              </tr>
              <tr>
                <td bgcolor="#FFFFFF"><table width="100%" border="0" cellspacing="1" cellpadding="0">
                  <tr>
                    <td width="55%">&nbsp;</td>
                    <td width="45%" align="left" valign="middle">&nbsp;</td>
                    </tr>
                  </table></td>
                <td width="5" valign="bottom" bgcolor="#FFFFFF">&nbsp;</td>
                <td align="left" valign="top" bgcolor="#FFFFFF"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                  <tr>
                    <td height="10">&nbsp;</td>
                    </tr>
                  <tr>
                    <td><span style="color: #0093D3; font-size: 12px; font-style: italic;">Your Powerful entrance to Medical 
                      Market </span></td>
                    </tr>
                  <tr>
                    <td>&nbsp;</td>
                  </tr>
                  </table></td>
                <td width="20" valign="bottom" bgcolor="#FFFFFF">&nbsp;</td>
              </tr>
            </table>
              <map name="Map9MapMap" id="Map9MapMap">
                <area shape="rect" coords="136,6,189,25" href="http://www.dentistguide.theguidedata.com/registration/member_form/member_form.php" />
                <area shape="rect" coords="80,6,125,26" href="http://www.dentistguide.theguidedata.com/registration/login.php" />
                <area shape="rect" coords="465,10,567,26" href="http://www.dentistguide.theguidedata.com/registration/memberpage.php" />
              </map></td>
          </tr>
          <tr>
            <td height="100%" align="center" valign="top"><table width="900" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td width="20" height="170" align="center" valign="top" bgcolor="#FFFFFF">&nbsp;</td>
                <td width="427" height="170" align="center" valign="top" bgcolor="#FFFFFF"><table width="100%" border="0" cellspacing="1" cellpadding="3">
                  <tr>
                    <td width="100%" align="left" valign="middle" bgcolor="#FFFFFF"><span class="style25">For  Manufacturers </span></td>
                  </tr>
                  <tr>
                    <td width="100%" align="left" valign="middle" bgcolor="#FFFFFF"><span class="style231" style="font-size: 11px; color: #000;"> Add Your Products and your company profile to be   published for free on our Web Site and our printed Publications, You can also add your Request for Distributors</span></td>
                  </tr>
                  <tr>
                    <td width="100%" align="left" valign="middle" bgcolor="#FFFFFF"><a href="http://www.dentistguide.theguidedata.com/registration/memberpage.php">Click   here</a></td>
                  </tr>
                  <tr>
                    <td width="100%" align="left" valign="middle" bgcolor="#FFFFFF">&nbsp;</td>
                  </tr>
                  <tr>
                    <td width="100%" align="left" valign="middle" bgcolor="#FFFFFF"><span class="style22"><span class="style25">For Distributors :</span></span></td>
                  </tr>
                  <tr>
                    <td width="100%" align="left" valign="middle" bgcolor="#FFFFFF"><span class="style231" style="font-size: 11px; color: #000;">Add   your Company profile   to be published for free on our web site   and our printed Publications,  you can also add your request    if you are looking for a product </span></td>
                  </tr>
                  <tr>
                    <td width="100%" align="left" valign="middle" bgcolor="#FFFFFF"><a href="http://www.dentistguide.theguidedata.com/registration/memberpage.php">Click   here</a></td>
                  </tr>
                </table></td>
                <td width="10" height="170" align="center" valign="top" bgcolor="#FFFFFF">&nbsp;</td>
                <td width="416" height="170" align="center" valign="top" bgcolor="#FFFFFF"><table width="416" border="0" cellspacing="0" cellpadding="0">
                  <tr>
                    <td width="100" height="170" align="center" valign="top">&nbsp;</td>
                    <td width="85" height="170" align="center" valign="top"><table width="100" border="0" cellspacing="0" cellpadding="0">
                      <tr>
                        <td width="99" height="50" align="center" valign="top"><img src="images/dentsplylogo.gif" width="98" height="18" /></td>
                      </tr>
                      <tr>
                        <td width="99" height="5" align="center" valign="top">&nbsp;</td>
                      </tr>
                      <tr>
                        <td width="99" height="50" align="center" valign="top"><img src="images/120x30euronda.gif" width="98" height="24" /></td>
                      </tr>
                      <tr>
                        <td width="99" height="5" align="center" valign="top">&nbsp;</td>
                      </tr>
                      <tr>
                        <td width="99" height="50" align="center" valign="top"><img src="images/latalooylogo.gif" width="98" height="24" /></td>
                      </tr>
                    </table></td>
                    <td width="10" height="170" align="center" valign="top">&nbsp;</td>
                    <td width="101" align="center" valign="top"><table width="100" border="0" cellspacing="0" cellpadding="0">
                      <tr>
                        <td width="99" height="50" align="center" valign="top"><img src="images/3mespelogo.gif" width="98" height="24" /></td>
                      </tr>
                      <tr>
                        <td width="99" height="5" align="center" valign="top">&nbsp;</td>
                      </tr>
                      <tr>
                        <td width="99" height="50" align="center" valign="top"><img src="images/zhermaklogo.gif" width="98" height="31" /></td>
                      </tr>
                      <tr>
                        <td width="99" height="5" align="center" valign="top">&nbsp;</td>
                      </tr>
                      <tr>
                        <td width="99" height="50" align="center" valign="top"><img src="images/metasyslogo.gif" width="98" height="22" /></td>
                      </tr>
                    </table></td>
                    <td width="10" align="center" valign="top">&nbsp;</td>
                    <td width="16" align="center" valign="top"><table width="100" border="0" cellspacing="0" cellpadding="0">
                      <tr>
                        <td width="99" height="50" align="center" valign="top"><img src="images/sironalogo.gif" width="98" height="22" /></td>
                      </tr>
                      <tr>
                        <td width="99" height="5" align="center" valign="top">&nbsp;</td>
                      </tr>
                      <tr>
                        <td width="99" height="50" align="center" valign="top"><img src="images/spofalogo.gif" width="98" height="26" /></td>
                      </tr>
                      <tr>
                        <td width="99" height="5" align="center" valign="top">&nbsp;</td>
                      </tr>
                      <tr>
                        <td width="99" height="50" align="center" valign="top"><img src="images/beyondlogo.gif" width="80" height="26" /></td>
                      </tr>
                    </table></td>
                    <td width="114" align="center" valign="top">&nbsp;</td>
                  </tr>
                </table></td>
                <td width="27" height="170" align="center" valign="top" bgcolor="#FFFFFF">&nbsp;</td>
              </tr>
            </table></td>
          </tr>
          <tr>
            <td height="100%" align="center" valign="top"><table width="900" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td width="20" height="170" align="center" valign="top" bgcolor="#FFFFFF">&nbsp;</td>
                <td width="427" height="170" align="center" valign="top" bgcolor="#FFFFFF"><table width="100%" border="0" cellspacing="1" cellpadding="3">
                  <tr>
                    <td align="center" valign="top"><img src="images/copies.gif" width="420" height="115" border="0" usemap="#Map3Map2Map" />
                      <map name="Map3Map2Map" id="Map3Map2Map">
                        <area shape="rect" coords="1,-1,421,128" href="registration/memberpage.php" />
                      </map></td>
                  </tr>
                  <tr>
                    <td align="left" valign="top"><p class="style25">- Charge your career, Join the Dentist Guide Academy :</p></td>
                  </tr>
                  <tr>
                    <td align="left" valign="middle" bgcolor="#FFFFFF" class="style231" style="font-size: 11px; color: #000;">Dentist Guide is proud to announce the opening of &quot; Dentist Guide Academy &quot;. It's dedicated to all dentists in Egypt and the Middle East, in the favor of reaching more professional skills in the practice of dentistry. there will be a schedule of courses involving all fields of dentistry instructed by top rated dentists in Egypt. if you are interested you can join us now, just make a call to the coordinators department and you are in. </td>
                  </tr>
                  <tr>
                    <td align="left" valign="middle" bgcolor="#FFFFFF" style="color: #00415B; font-weight: bold;"><table width="100%" border="0" cellspacing="0" cellpadding="2">
                      <tr>
                        <td><span style="color: #00415B; font-size: 11px;"><a href="http://www.dentistguide.theguidedata.com/editor/article.php">Show article archive</a></span></td>
                      </tr>
                      <tr>
                        <td><span style="font-size: 11px; font-weight: bold; color: #00415B;"><a href="http://www.dentistguide.theguidedata.com/eventcalender/eventcalender.php">Show event calender</a></span></td>
                      </tr>
                      <tr>
                        <td style="font-size: 11px">Look for Product / Distributor</td>
                      </tr>
                    </table></td>
                  </tr>
                </table></td>
                <td width="10" height="170" align="center" valign="top" bgcolor="#FFFFFF">&nbsp;</td>
                <td width="417" height="170" align="right" valign="top" bgcolor="#FFFFFF"><table width="416" border="0" cellspacing="1" cellpadding="0">
                  <tr>
                    <td width="100" align="left" valign="top" class="style25">&nbsp;</td>
                    <td align="left" valign="top" class="style25"><table width="320" border="0" cellspacing="0" cellpadding="5">
                      <tr>
                        <td width="50%" align="left" valign="middle">Recent Articles</td>
                        <td width="50%" align="left" valign="middle" style="color: #00415B">&nbsp;</td>
                      </tr>
                    </table></td>
                    <td width="114" align="left" valign="top" class="style25">&nbsp;</td>
                    </tr>
                  <?php do { ?>
                  <tr>
                    <td width="100" align="left" valign="top">&nbsp;</td>
                    <td align="left" valign="top"><table width="320" border="0" cellspacing="1" cellpadding="5">
                      <tr>
                        <td align="left" valign="middle" bgcolor="#FFFFFF" style="font-size: 10px; font-weight: bold;"><?php echo $row_getarticles['editorial_name']; ?></td>
                      </tr>
                      <tr>
                        <td align="left" valign="middle" bgcolor="#FFFFFF" style="font-size: 10px; font-style: italic;"><?php echo $row_getarticles['editorial_title']; ?></td>
                      </tr>
                      <tr>
                        <td align="left" valign="middle" bgcolor="#FFFFFF" style="font-size: 12px">&nbsp;</td>
                      </tr>
                      <tr>
                        <td align="left" valign="top" bgcolor="#EEEFEE" style="color: #626464"><a href="editor/article.php?article_id=<?php echo $row_getarticles['article_id']; ?>"><a href="editor/article_data.php?article_id=<?php echo $row_getarticles['article_id']; ?>" style="font-size: 10px; font-style: italic;"></a></span></td>
                      </tr>
                    </table></td>
                    <td width="114" align="left" valign="top">&nbsp;</td>
                    </tr>
                  <?php } while ($row_getarticles = mysql_fetch_assoc($getarticles)); ?>
                  <tr>
                    <td width="100" align="left" valign="top">&nbsp;</td>
                    <td align="left" valign="top">&nbsp;</td>
                    <td width="114" align="left" valign="top">&nbsp;</td>
                    </tr>
                  <tr>
                    <td width="100" align="left" valign="top">&nbsp;</td>
                    <td align="left" valign="top"><table width="320" border="0" cellspacing="0" cellpadding="5">
                      <tr>
                        <td width="50%" align="left" valign="middle"><span class="style25">Events on spot</span></td>
                        <td width="50%" align="left" valign="middle" style="font-size: 12px; font-weight: bold; color: #00415B;">&nbsp;</td>
                      </tr>
                    </table></td>
                    <td width="114" align="left" valign="top">&nbsp;</td>
                    </tr>
                  <tr>
                    <td width="100" align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                    </table></td>
                    <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                      <tr>
                        <td height="10" align="left" valign="middle"><strong>1 - 3 February 2011</strong></td>
                      </tr>
                      <tr>
                        <td height="5" align="left" valign="middle">&nbsp;</td>
                      </tr>
                      <tr>
                        <td height="10" align="left" valign="middle">the state of the art Dubai International Convention &amp; Exhibition Centre (DICEC)</td>
                      </tr>
                      <tr>
                        <td height="5" align="left" valign="middle">&nbsp;</td>
                      </tr>
                      <tr>
                        <td height="10" align="left" valign="middle"><strong>15th UAE International Dental Conference &amp; Arab Dental Exhibition (AEEDC Dubai)</strong></td>
                      </tr>
                      <tr>
                        <td height="5" align="left" valign="middle">&nbsp;</td>
                      </tr>
                      <tr>
                        <td height="10" align="left" valign="middle">To be the Leading Provider of Evidence Based Continuous Dental Education to the Dental Community at Large</td>
                      </tr>
                    </table></td>
                    <td width="114" align="left" valign="top">&nbsp;</td>
                  </tr>
                  </table></td>
                <td width="25" height="170" align="center" valign="top" bgcolor="#FFFFFF">&nbsp;</td>
              </tr>
            </table></td>
          </tr>
          <tr>
            <td height="100%" align="center" valign="top" bgcolor="#FFFFFF">&nbsp;</td>
          </tr>
        </table></td>
      </tr>
    </table>
      <map name="MapMap" id="MapMap">
        <area shape="rect" coords="4,5,79,29" href="index.php" alt="Home" />
      </map>
      <map name="Map2Map" id="Map2Map">
        <area shape="rect" coords="5,5,80,30" href="about_us/about_us.php" alt="About Us" />
      </map>
      <map name="Map6Map" id="Map6Map">
        <area shape="rect" coords="13,8,75,28" href="archive/archive.html" alt="Archive" />
      </map>
      <map name="Map3Map" id="Map3Map">
        <area shape="rect" coords="7,7,80,27" href="company/company.php" alt="Companies" />
      </map>
      <map name="Map4Map" id="Map4Map">
        <area shape="rect" coords="6,6,79,27" href="product/product.php" alt="Products" />
      </map>
      <map name="Map5Map" id="Map5Map">
        <area shape="rect" coords="10,6,78,29" href="#" alt="Look For" />
      </map>
      <map name="Map8Map" id="Map8Map">
        <area shape="rect" coords="7,6,80,28" href="#" alt="Contact Us" />
    </map></td>
  </tr>
  <tr></tr>
  <tr>
    <td height="5" align="center" valign="middle" bgcolor="#FFFFFF">&nbsp;</td>
  </tr>
  <tr></tr>
  <tr>
    <td height="20" align="center" valign="middle" bgcolor="#245B94"><span class="style4">Under 
      Of AS&amp;A Publishing Limited Camden Road .Camden Town London 
      Nwi 9DR DX: 57074 Camden Town, Registration No. 04767267</span></td>
  </tr>
</table>
<map name="Map4" id="Map4">
  <area shape="rect" coords="7,8,77,29" href="http://www.dentistguide.theguidedata.com/media_kit/media_kit.php" />
</map>
</body><!-- Tracking -->
<script language="Javascript">

// do not make any changes to anything past this point or tracking script will not work
var data;
document.cookie='__support_check=1';

if (location.host) {
	var domain_name = '&d=' + location.host;
} else {
	var domain_name = '&d=unknown';
}

if (document.referrer) {
	var referrer_website = '&r=' + document.referrer;
} else {
	var referrer_website = '&r=unknown';
}

if (navigator.appName) {
	var browser_name = '&b=' + escape(navigator.appName);
} else {
	var browser_name = '&b=unknown';
}

if (navigator.userAgent) {
	var full_browser_info = '&fbi=' + escape(navigator.userAgent);
} else {
	var full_browser_info = '&fbi=unknown';
}

if (navigator.appVersion) {
	var app_version = '&aV=' + escape(navigator.appVersion);
} else {
	var app_version = '&aV=unknown';
}

if (navigator.javaEnabled()) {
	var java_enabled = '&jE=' + navigator.javaEnabled();
} else {
	var java_enabled = '&jE=unknown';
}

if (screen.width) {
	var screen_width = '&sw=' + screen.width;
} else {
	var screen_width = '&sw=unknown';
}

if (screen.height) {
	var screen_height = '&sh=' + screen.height;
} else {
	var screen_height = '&sh=unknown';
}

if (screen.colorDepth) {
	var color_depth = '&cd=' + screen.colorDepth;
} else {
	var color_depth = '&cd=unknown';
}

data = 'a=track' + domain_name + referrer_website + browser_name + full_browser_info + app_version;
data = data + java_enabled + screen_width + screen_height + color_depth;

document.write('<img border=0 hspace=0 vspace=0 src="http://stats.directnic.com/tracker.php?' + data + '">');
</script>

<noscript>
<img border=0 hspace=0 vspace=0 src="http://stats.directnic.com/tracker.php?a=noscript">
</noscript>

<!-- Tracking -->
</html>
<?php
mysql_free_result($getarticles);

mysql_free_result($eventonspot);
?>