<?php require_once('../Connections/mbdsa.php'); ?>
<?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;
}
}

mysql_select_db($database_mbdsa, $mbdsa);
$query_category = "SELECT * FROM category ORDER BY category ASC";
$category = mysql_query($query_category, $mbdsa) or die(mysql_error());
$row_category = mysql_fetch_assoc($category);
$totalRows_category = mysql_num_rows($category);

mysql_select_db($database_mbdsa, $mbdsa);
$query_provinces = "SELECT * FROM province ORDER BY province ASC";
$provinces = mysql_query($query_provinces, $mbdsa) or die(mysql_error());
$row_provinces = mysql_fetch_assoc($provinces);
$totalRows_provinces = mysql_num_rows($provinces);

$colname_categoryvalues = "-1";
if (isset($_GET['catID'])) {
  $colname_categoryvalues = $_GET['catID'];
}
mysql_select_db($database_mbdsa, $mbdsa);
$query_categoryvalues = sprintf("SELECT * FROM catvalue WHERE catID = %s ORDER BY catvalues ASC", GetSQLValueString($colname_categoryvalues, "int"));
$categoryvalues = mysql_query($query_categoryvalues, $mbdsa) or die(mysql_error());
$row_categoryvalues = mysql_fetch_assoc($categoryvalues);
$totalRows_categoryvalues = mysql_num_rows($categoryvalues);

mysql_select_db($database_mbdsa, $mbdsa);
$query_cat = "SELECT * FROM category ORDER BY category ASC";
$cat = mysql_query($query_cat, $mbdsa) or die(mysql_error());
$row_cat = mysql_fetch_assoc($cat);
$totalRows_cat = mysql_num_rows($cat);

$colname_pictures = "-1";
if (isset($_GET['businessID'])) {
  $colname_pictures = $_GET['businessID'];
}
mysql_select_db($database_mbdsa, $mbdsa);
$query_pictures = sprintf("SELECT * FROM pictures WHERE businessID = %s", GetSQLValueString($colname_pictures, "text"));
$pictures = mysql_query($query_pictures, $mbdsa) or die(mysql_error());
$row_pictures = mysql_fetch_assoc($pictures);
$totalRows_pictures = mysql_num_rows($pictures);

$colname_Businesses = "-1";
if (isset($_GET['businessID'])) {
  $colname_Businesses = $_GET['businessID'];
}
mysql_select_db($database_mbdsa, $mbdsa);
$query_Businesses = sprintf("SELECT * FROM businesses WHERE businessID = %s", GetSQLValueString($colname_Businesses, "int"));
$Businesses = mysql_query($query_Businesses, $mbdsa) or die(mysql_error());
$row_Businesses = mysql_fetch_assoc($Businesses);
$totalRows_Businesses = mysql_num_rows($Businesses);

$colname_reviews = "-1";
if (isset($_GET['businessID'])) {
  $colname_reviews = $_GET['businessID'];
}
mysql_select_db($database_mbdsa, $mbdsa);
$query_reviews = sprintf("SELECT * FROM reviews WHERE businessID = %s", GetSQLValueString($colname_reviews, "text"));
$reviews = mysql_query($query_reviews, $mbdsa) or die(mysql_error());
$row_reviews = mysql_fetch_assoc($reviews);
$totalRows_reviews = mysql_num_rows($reviews);
?>
<?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['textfield'])) {
  $loginUsername=$_POST['textfield'];
  $password=$_POST['textfield2'];
  $MM_fldUserAuthorization = "";
  $MM_redirectLoginSuccess = "../user_pages/user_profile.php";
  $MM_redirectLoginFailed = "../user_pages/denied_login.php";
  $MM_redirecttoReferrer = false;
  mysql_select_db($database_mbdsa, $mbdsa);
  
  $LoginRS__query=sprintf("SELECT name, password FROM `user` WHERE name=%s AND password=%s",
    GetSQLValueString($loginUsername, "text"), GetSQLValueString($password, "text")); 
   
  $LoginRS = mysql_query($LoginRS__query, $mbdsa) 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>Untitled Document</title>
<style type="text/css">
<!--
#search {
	height: 60px;
	width: 950px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
	margin-left: 0px;
	border: thin none #060;
}
#container {
	height: auto;
	width: 950px;
	margin-right: auto;
	margin-left: auto;
	border: thin solid #030;
	background-color: #FFF;
}
#header {
	height: 150px;
	width: 950px;
	background-color: #FFF;
	border-bottom-width: thin;
	border-bottom-style: solid;
	border-bottom-color: #030;
}
#menubar {
	height: 65px;
	width: auto;
	margin-right: auto;
	margin-left: auto;
	border-top-width: thin;
	border-left-width: thin;
	border-right-style: none;
	border-left-style: none;
	border-top-color: #999;
	border-right-color: #999;
	border-bottom-color: #999;
	border-left-color: #999;
	border-top-style: none;
	border-bottom-style: none;
	padding-right: 0px;
	padding-left: 0px;
	margin-top: 0px;
	margin-bottom: 0px;
}
.redbox {
	border: thin solid #060;
	font-family: Tahoma;
	font-size: 12px;
	color: #333;
}
.redwrting {
	font-family: Verdana;
	font-size: 14px;
	color: #333;
}
#maincontent {
	height: auto;
	width: 950px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
	margin-left: 0px;
}
#adds {
	float: right;
	height: auto;
	width: 300px;
	margin-top: 10px;
	margin-right: 10px;
	margin-bottom: 5px;
	margin-left: 5px;
	border-top-width: medium;
	border-right-width: medium;
	border-bottom-width: thin;
	border-left-width: thin;
	border-top-style: none;
	border-right-style: none;
	border-bottom-style: solid;
	border-left-style: solid;
	border-top-color: #CCC;
	border-right-color: #CCC;
	border-bottom-color: #CCC;
	border-left-color: #CCC;
}
#messagebox {
	height: auto;
	width: 600px;
	margin: 10px;
	border: medium solid #CCC;
}
#hi {
	float: right;
	height: 60px;
	width: 300px;
	background-color: #030;
	border: thin solid #060;
	margin-top: 5px;
	margin-right: 10px;
	margin-bottom: 5px;
	margin-left: 5px;
}
#topleft {
	float: left;
	height: 150px;
	width: 150px;
}
#topbottom {
	float: right;
	height: 50px;
	width: 650px;
	margin-top: 5px;
	background-color: #F7F7F7;
	margin-right: 50px;
	margin-left: auto;
	border: thin solid #CCC;
}
#writingontop {
	float: left;
	height: 30px;
	width: 350px;
	margin-right: 0px;
	margin-left: 25px;
	margin-top: 25px;
}
#middletop {
	float: right;
	height: 80px;
	width: 350px;
	padding-top: 0px;
}
-->
</style>
<style type="text/css">
<!--
body {
	background-color: #DADADA;
}
.fffffffffffffffffffff {
	font-family: Tahoma;
	font-size: 12px;
	color: #333;
	font-weight: normal;
}
.loginbox {	font-family: Tahoma;
	font-size: 12px;
	color: #000;
	border: thin none #060;
	font-weight: bold;
}
.topbox {
	border-top-width: thick;
	border-left-width: thick;
	border-top-style: none;
	border-left-style: none;
	border-top-color: #999;
	border-left-color: #666;
	border-bottom-style: none;
	font-family: "Trebuchet MS";
	font-size: 20px;
	color: #063;
	border-right-style: none;
	font-weight: normal;
}
.ttttttttt {
	border: thin solid #CCC;
}
.topbox1 {	border-top-width: thick;
	border-left-width: thick;
	border-top-style: none;
	border-left-style: none;
	border-top-color: #999;
	border-left-color: #666;
	border-bottom-style: none;
	font-family: "Lucida Sans Unicode";
	font-size: 18px;
	color: #060;
	border-right-style: none;
	font-weight: normal;
}
.hhhhhhhhhhh {
	font-family: Tahoma;
	font-size: 12px;
	color: #006;
	border-bottom-width: medium;
	border-bottom-style: solid;
	border-bottom-color: #400000;
	border-top-width: thin;
	border-top-style: none;
	border-left-width: thick;
	border-left-style: none;
	border-left-color: #666;
	background-repeat: repeat-x;
	border-top-color: #666;
	border-right-width: thick;
	border-right-style: none;
	border-right-color: #D8E4FC;
	background-color: #FFF;
}
.werewrewrewwerew {
	font-family: Arial;
	font-size: 12px;
	color: #333;
	font-weight: normal;
}
.xxxxxxxxxxxxxxxx {
	font-family: Tahoma;
	font-size: 12px;
	color: #666;
	font-weight: normal;
}
.aaaaaaaaaaaaaaaaaaaaaaaaaaaa {	border: thin solid #700;
}
.bbbbbbbbbbbbbbbbbbbbbbbbbbbbb {
	font-family: Tahoma;
	font-size: 12px;
	color: #FFF;
	font-weight: normal;
	background-repeat: repeat;
	background-position: right top;
	background-color: #FFF;
	border-top-width: thin;
	border-right-width: thin;
	border-bottom-width: thin;
	border-left-width: thin;
	border-top-style: solid;
	border-right-style: solid;
	border-bottom-style: solid;
	border-left-style: solid;
	border-top-color: #CCC;
	border-right-color: #CCC;
	border-bottom-color: #800000;
	border-left-color: #CCC;
}
.white {font-family: Tahoma;
	font-size: 12px;
	color: #000;
}
-->
</style>
<script src="../SpryAssets/SpryMenuBar.js" type="text/javascript"></script>
<link href="../SpryAssets/SpryMenuBarHorizontal.css" rel="stylesheet" type="text/css" />
<link href="../SpryAssets/SpryMenuBarVertical.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
.qqqqq {font-family: Verdana;
	font-size: 14px;
	color: #030;
}
.qwert {font-family: Verdana;
	font-size: 14px;
	color: #030;
	font-style: italic;
	font-weight: normal;
}
.style22 {font-family: Verdana;
	font-size: 14px;
	color: #060;
}
.style30 {font-size: 24px; font-weight: bold; }
.wertrr {font-family: Tahoma;
	font-size: 14px;
	color: #000;
	font-weight: normal;
	border-bottom-width: thin;
	border-bottom-style: none;
	border-bottom-color: #CCC;
	background-color: #F0F0F4;
	margin-bottom: auto;
}
.zazazaz {	font-family: Tahoma;
	font-size: 14px;
	color: #060;
	font-weight: normal;
}
-->
</style>
</head>

<body>
<div class="container" id="container">
  <div class="header" id="header">
  <div class="middletop" id="middletop">
    <form id="form3" name="form3" method="POST" action="<?php echo $loginFormAction; ?>">
      <p class="loginbox">
        <label> <span class="xxxxxxxxxxxxxxxx">Username</span>
          <input name="textfield" type="text" id="textfield" />
          <a href="../user_pages/registration.php" class="xxxxxxxxxxxxxxxx"> Register with MBDSA</a><br />
          <br />
          <span class="xxxxxxxxxxxxxxxx">Password</span></label>
        <label>
          <input name="textfield2" type="password" id="textfield2" />
        </label>
        <input type="submit" name="button" id="button" value="Log In" />
      </p>
</form>
  </div>
    <div class="topleft" id="topleft"><img src="../untitled.JPG" alt="Mbdsa Logo" width="152" height="149" border="0" longdesc="http://www.mbdsa.co.za" /></div>
    <div class="topbox" id="writingontop">
      <h1 class="topbox">Muslim Business Directory South Africa</h1>
    </div>
  </div>
  <div class="search" id="search">
    <ul id="MenuBar1" class="MenuBarHorizontal">
      <li><a href="../index.php">Home Page</a></li>
      <li><a class="MenuBarItemSubmenu" href="../business_search/search_category.php">Businesses</a>
        <ul>
          <li><a href="../business_search/search_category.php">Search Businesses</a></li>
          <li><a href="../user_pages/business/select_category.php">Add Businesses</a></li>
          <li><a href="../reviews/select_business.php">Write Review</a></li>
        </ul>
      </li>
      <li><a href="../home_industries/home_industries.php" class="MenuBarItemSubmenu">Home Industries</a>
        <ul>
          <li><a href="../home_industries/home_industries.php">Seacrh Home Industries</a></li>
          <li><a href="../home_industries/add_homeindustry.php">Add a Home Industry</a></li>
          <li><a href="../reviews/select_hi.php">Write a review</a></li>
        </ul>
      </li>
      <li><a href="../extras/classifieds.php">Classifieds</a></li>
      <li><a href="../extras/property.php">Property</a></li>
      <li><a href="list.htm">Articles</a></li>
      <li><a href="../extras/vacancies.php">Job Feeds</a></li>
<li><a href="#" class="MenuBarItemSubmenu">Resources</a>
  <ul>
    <li><a href="../resources/Islamicwill.doc">Islamic Will </a></li>
    <li><a href="../resources/Quraan_search.php">Quraan Search</a></li>
    <li><a href="../resources/zakatcalc.xls">Zakaat Claculator</a></li>
<li><a href="../resources/Hadith_Search.php">Hadith Search</a></li>
    <li><a href="../resources/Islamic_tube.php">Islamic Tube</a></li>
    <li><a href="../resources/Quraan_recitation.php">Quraan Recitation</a></li>
  </ul>
</li>
<li><a href="#" class="MenuBarItemSubmenu">Today Page</a>
  <ul>
    <li><a href="../resources/Namaaz_times.php">Namaaz Times</a></li>
    <li><a href="../resources/news_weather.php">News Weather Currency</a></li>
    <li><a href="../resources/Cricket.php">Cricket score &amp; news</a></li>
    <li><a href="../resources/soccer.php">Soccer News &amp; scores</a></li>
    <li><a href="../resources/games.php">Games</a></li>
  </ul>
</li>
<li><a href="../extras/Masaajid.php">Masaajid List</a></li>
<li><a href="../resources/charity/charitys.php">Charirty's</a></li>
<li><a href="../resources/islamic_schools.php">Islamic Schools</a></li>
<li><a href="../extras/transprt_liftclubs.php">Lift Clubs </a></li>
<li><a href="../contact_us.html">Contact Us</a></li>
    </ul>
  </div>
  <div class="maincontent" id="maincontent">
    <div class="adds" id="adds">
      <table width="300" height="550" border="1" cellpadding="5" cellspacing="0" class="bbbbbbbbbbbbbbbbbbbbbbbbbbbbb">
        <tr>
          <td width="49%" height="121" align="center" valign="top" bgcolor="#FFFFFF"><a href="http://www.rapidsoft.co.za"><img src="../pictures/ads/rapad.gif" alt="RapidSoft" width="200" height="202" border="0" longdesc="http://www.rapidsoft.co.za" /></a></td>
        </tr>
        <tr>
          <td height="214" align="center" valign="middle" bgcolor="#FFFFFF"><p class="white"><a href="http://zyelabs.net"><img src="../pictures/ads/zyelabs.gif" alt="zye labs" width="200" height="200" border="0" longdesc="http://zyelabs.net/" /></a></p></td>
        </tr>
        <tr>
          <td height="213" align="left" valign="top" bgcolor="#FFFFFF"><a href="http://www.mbdsa.co.za/home_industries/PROFILE.php?Id=1"><img src="../pictures/ss.JPG" alt="Unty shameem" width="229" height="169" border="0" longdesc="http://www.mbdsa.co.za/home_industries/PROFILE.php?Id=1" /></a></td>
        </tr>
      </table>
    </div>
    <div class="messagebox" id="messagebox">
      <p><span class="fffffffffffffffffffff">8 March 2010</span> - <span class="zazazaz"><a href="http://www.mbdsa.co.za/articles/janazah.doc">Janzah Document</a></span></p>
      <p><span class="fffffffffffffffffffff">5 January 2009 - </span><a href="joking.htm" class="zazazaz">Joking in islam</a></p>
      <p><span class="fffffffffffffffffffff">22 December 2009</span> - <a href="Fruits.htm" class="zazazaz">Fruits and their Benefits</a></p>
      <p><span class="fffffffffffffffffffff">20 November 2009 -</span> <a href="PolesOfIslam.htm" class="zazazaz">Poles Of Islam</a></p>
      <p><span class="fffffffffffffffffffff">20 November -</span> <a href="Guns.htm" class="zazazaz">With gus we are citizen</a></p>
      <p><span class="fffffffffffffffffffff">17 november 2009</span> - <a href="braindamage.htm" class="zazazaz">Brain damaging habbits</a></p>
<p><span class="fffffffffffffffffffff">16 November 2009</span> -<a href="WomenIslam.htm" class="zazazaz"> Islam And Women</a></p>
      <p><span class="fffffffffffffffffffff">10 November 2009</span> - <span class="fffffffffffffffffffff"><a href="Inventors.htm" class="zazazaz">How Muslim Inventors Changed the world</a></span></p>
      <p><span class="fffffffffffffffffffff">4 November 2009</span> -   <span class="zazazaz"><a href="AboutIslamWorld.htm" class="zazazaz">About Islam &amp; World Freedom</a></span></p>
      <p><span class="fffffffffffffffffffff">2 November 2009</span> - <a href="cucumber.htm" class="zazazaz">Cucumber</a></p>
      <p><span class="fffffffffffffffffffff">16 October 2009</span> - <a href="pseudo.htm" class="zazazaz">why pseudo science fails to explain GOD</a></p>
      <p><span class="fffffffffffffffffffff">15 September 2009</span> - <a href="msg.htm"><span class="zazazaz">MSG Slow Poison (read for your health)</span></a></p>
      <p><span class="fffffffffffffffffffff">11 September 2009</span> -<a href="ratw.htm"> <span class="zazazaz">Ramdaan Pictues from around the world</span></a></p>
      <p><span class="fffffffffffffffffffff">10 September 2009</span> - <a href="salatut.htm" class="zazazaz">Salatut Tasbeeh</a></p>
      <p><span class="fffffffffffffffffffff">10 September 2009 - <a href="MyHands.pdf" class="zazazaz">My mothers Hands - inspirational</a></span></p>
      <p><span class="fffffffffffffffffffff">8 September 2009 - </span><a href="laylatul_qadr.htm"><span class="zazazaz">Laylatul Qadr</span></a></p>
      <p><span class="fffffffffffffffffffff">7 September 2009</span> - <span class="topbox"><a href="Honey.htm" class="zazazaz">The Sweetness of Honey</a></span></p>
      <p><span class="fffffffffffffffffffff">3 September 2009</span> - <a href="tarawee.htm" class="zazazaz">Rewards for reading tarawee</a></p>
      <p><span class="fffffffffffffffffffff">3 September 2009</span> - <a href="muslimhusbandhtm.html" class="zazazaz">What a Muslim husband should do for his wife</a></p>
      <p><span class="fffffffffffffffffffff">2 September 2009</span> - <a href="911.htm" class="zazazaz">Did you know 9 /11</a></p>
      <p><span class="fffffffffffffffffffff">30 August 2009 - </span><a href="ihpics.htm" class="zazazaz">Must See Islamic History Pictures</a></p>
      <p><span class="fffffffffffffffffffff">30 August 2009 -</span> <a href="hints.htm" class="zazazaz">Handy Hints @ home</a></p>
      <p><span class="fffffffffffffffffffff">28 August 2009</span> - <a href="spice.htm" class="zazazaz">Indian Spice Remedies</a></p>
      <p><span class="fffffffffffffffffffff">28 August 2009</span> - <a href="letter.htm" class="zazazaz">A letter from a Christian to Muslim women.</a> </p>
      <h2><span class="fffffffffffffffffffff">27 August 2009</span> <span class="fffffffffffffffffffff">-</span> <a href="pharmacy.htm" class="zazazaz">Allah Pharmacy</a> <span class="zazazaz">-</span> <span class="zazazaz">( Foods etc. )</span></h2>
      <h2><span class="fffffffffffffffffffff">27 August 2009</span> <span class="fffffffffffffffffffff">-</span> <a href="marriage.htm" class="zazazaz">Article on marriage and nikkah</a><span class="zazazaz"> - ( espcially for those not yet married )</span></h2>
      <h2 class="zazazaz"><span class="fffffffffffffffffffff">27 August 2009</span> - <a href="islam1428htm.html" class="zazazaz">Islam Told 1428 years ago </a></h2>
      <p>&nbsp;</p>
      <p>&nbsp;</p>
      <p>&nbsp;</p>
      <p>&nbsp;</p>
      <p>&nbsp;</p>
      <p>&nbsp;</p>
      <p>&nbsp;</p>
    </div>
  </div>
</div>
<script type="text/javascript">
<!--
var MenuBar1 = new Spry.Widget.MenuBar("MenuBar1", {imgDown:"SpryAssets/SpryMenuBarDownHover.gif", imgRight:"SpryAssets/SpryMenuBarRightHover.gif"});
//-->
</script>
</body>
</html>
<?php
mysql_free_result($category);

mysql_free_result($provinces);

mysql_free_result($categoryvalues);

mysql_free_result($cat);

mysql_free_result($pictures);

mysql_free_result($Businesses);

mysql_free_result($reviews);
?>