<?php require_once('Connections/JCH_Sql.php'); ?>
<?php
$currentPage = $_SERVER["PHP_SELF"];

$maxRows_RSClient = 20;
$pageNum_RSClient = 0;
if (isset($_GET['pageNum_RSClient'])) {
  $pageNum_RSClient = $_GET['pageNum_RSClient'];
}
$startRow_RSClient = $pageNum_RSClient * $maxRows_RSClient;

mysql_select_db($database_JCH_Sql, $JCH_Sql);
$query_RSClient = "SELECT * FROM Clients WHERE Status = 'Available' ORDER BY Name ASC";
$query_limit_RSClient = sprintf("%s LIMIT %d, %d", $query_RSClient, $startRow_RSClient, $maxRows_RSClient);
$RSClient = mysql_query($query_limit_RSClient, $JCH_Sql) or die(mysql_error());
$row_RSClient = mysql_fetch_assoc($RSClient);

if (isset($_GET['totalRows_RSClient'])) {
  $totalRows_RSClient = $_GET['totalRows_RSClient'];
} else {
  $all_RSClient = mysql_query($query_RSClient);
  $totalRows_RSClient = mysql_num_rows($all_RSClient);
}
$totalPages_RSClient = ceil($totalRows_RSClient/$maxRows_RSClient)-1;

$queryString_RSClient = "";
if (!empty($_SERVER['QUERY_STRING'])) {
  $params = explode("&", $_SERVER['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_RSClient") == false && 
        stristr($param, "totalRows_RSClient") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_RSClient = "&" . htmlentities(implode("&", $newParams));
  }
}
$queryString_RSClient = sprintf("&totalRows_RSClient=%d%s", $totalRows_RSClient, $queryString_RSClient);

// configure to fit your needs
$to = "mr_azzj@yahoo.com";
$toname = "Webmaster";
$subject = "Feedback from Website";
// for Drupal users modify the form tag the same as the alias line in the page
// do not modify below this line
if (isset($_POST['sendnow']))
{
$from = $_POST['f_email'];
$fromname = $_POST['f_name'];
$fName = $_POST['f_name'];
$femail = $_POST['f_email'];
$fdesig = $_POST['f_designation'];
$fcompany = $_POST['f_company'];
$fcountry = $_POST['f_country'];
$fphone = $_POST['f_phone'];
$ffax = $_POST['f_fax'];
$fcommence = $_POST['f_commence'];
$fbandSolo = $_POST['f_bandSolo'];
$fbandStroll = $_POST['f_bandStroll'];
$fbandDuets = $_POST['f_bandDuets'];
$fbandStrings = $_POST['f_bandStrings'];
$fbandLounge = $_POST['f_bandLounge'];
$fbandShowband = $_POST['f_bandShowband'];
$message = $_POST['f_details'];
// extra info to add to message
$address = gethostbyaddr($_SERVER['REMOTE_ADDR']); 
$ip = gethostbyname($_SERVER['REMOTE_ADDR']); 
$timestamp = time (); 
$filename =  $_SERVER['PHP_SELF']; 
$location = $_SERVER['SERVER_NAME'];
// adding
$messagewithinfo = "Name = $fName <$femail> \n Designation = $fdesig \n Company name = $fcompany \n Country = $fcountry \n Phone No.= $fphone \n Fax No = $ffax \n Commencement Date = $fcommence \n Selected = $fbandSolo \n Selected = $fbandDuets \n Selected = $fbandLounge \n Selected = $fbandStroll \n Selected = $fbandShowband \n Selected = $fbandStrings \n  Wrote= \n $message
\n Extra info: \n IP =  $ip \n Address = $address \n Time at server = $timestamp \n Sent with this page = $locationn";
mail($to, $subject, $messagewithinfo, "From: $fromname <$from>\n" . "Reply-To: $from \n" . "X-Mailer: PHP/" . phpversion());
header("location:indextest.php");
}
?>
<!-- 	-->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>
<head>
<title>J C H O N L I N E | Our Clients</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<!--

function MM_reloadPage(init) {  //reloads the window if Nav4 resized
  if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
    document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
  else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
//-->
<script type="text/javascript" language="JavaScript1.2" src="stm31.js"></script>
<link href="Images/style.css" rel="stylesheet" type="text/css">
<style type="text/css">
body {	background-image: url(/Images/bg.jpg);}
</style>
</head>

<body topmargin="0" leftmargin="0" rightmargin="0" bottommargin="0">
<table width="780" height="" border="0" align="center" cellpadding="0" cellspacing="0"><!--DWLayoutTable-->
<tr>
	<td align="center"><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0" width="800" height="150">
      <param name="movie" value="Images/extras/banner2.swf">
      <param name="quality" value="high">
      <embed src="Images/extras/banner2.swf" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="800" height="150"></embed>
    </object></td>
</tr>
<tr>
	<td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td valign="top" bgcolor="#FFFFFF"><p class="Header1">Our Clients </p>          </td>
        </tr>
      <tr>
        <td valign="top" bgcolor="#FFFFFF"><img src="Images/world.gif" width="800" height="401"></td>
        </tr>
      <tr>
        <td valign="top" bgcolor="#FFFFFF"><table width="100%" border="0" cellspacing="0" cellpadding="5">
            <tr>
              <td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                <tr>
                  <td colspan="3" class="SmallTitle2">Markets Established; </td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                </tr>
                <tr>
                  <td align="center"><img src="Images/extras/flagMal.gif" width="50" height="33"></td>
                  <td align="center"><img src="Images/extras/flagSg.gif" width="50" height="33"></td>
                  <td align="center"><img src="Images/extras/flagIndo.gif" width="50" height="33"></td>
                  <td align="center"><img src="Images/extras/flagThai.gif" width="50" height="33"></td>
                  <td align="center"><img src="Images/extras/flagMynr.gif" width="50" height="33"></td>
                  <td align="center"><img src="Images/extras/flagEgypt.gif" width="50" height="33"></td>
                  <td align="center"><img src="Images/extras/flagThwn.gif" width="50" height="33"></td>
                  <td align="center"><img src="Images/extras/flagChina.gif" width="50" height="33"></td>
                  <td align="center"><img src="Images/extras/flafHK.gif" width="50" height="33"></td>
                  <td align="center"><img src="Images/extras/flagIndia.gif" width="50" height="33"></td>
                  <td align="center"><img src="Images/extras/flagSriLangka.gif" width="50" height="30"></td>
                  <td align="center"><img src="Images/extras/flagMaldives.gif" width="50" height="33"></td>
                  <td align="center"><img src="Images/extras/flagDjibouti.gif" width="50" height="33"></td>
                  <td align="center"><img src="Images/extras/flagSaipan.gif" width="50" height="33"></td>
                </tr>
                <tr>
                  <td align="center"><span class="text">Malaysia</span></td>
                  <td align="center"><span class="text">Singapore</span></td>
                  <td align="center"><span class="text">Indonesia</span></td>
                  <td align="center"><span class="text">Thailand</span></td>
                  <td align="center"><span class="text">Myanmar</span></td>
                  <td align="center"><span class="text">Egypt</span></td>
                  <td align="center"><span class="text">Taiwan</span></td>
                  <td align="center"><span class="text">China</span></td>
                  <td align="center"><span class="text">Hong Kong</span></td>
                  <td align="center"><span class="text">India</span></td>
                  <td align="center"><span class="text">Sri Lanka</span></td>
                  <td align="center"><span class="text">Maldives</span></td>
                  <td align="center"><span class="text">Djibouti</span></td>
                  <td align="center"><span class="text">Saipan</span></td>
                </tr>

              </table>
              <p align="left" class="default"><strong>JC Holdings</strong> to date handles more than a hundred bands which are presently booked in the finest hotels in Asia. The Group has under its wings, professional and talented musicians both local and international. These Performing Artistes have been constantly maintained and developed, as we the Group believe that we and our clients would not settle for anything less but the best.</p>
                <p class="default">Moreover the Group has also sustained good working relationship with its hotels clientle . We have been in good contact until this day with more than 100 clients, all of which belong to either four or five star hotel catergories in <strong>China</strong>, <strong>Dubai</strong>, <strong> Djibouti, Egypt, India</strong>,<strong> Indonesia, Malaysia</strong>, <strong>Maldives,</strong> <strong>Singapore</strong>, <strong>South Korea, Seychelles,</strong> <strong>Taiwan, Thailand</strong> and all around Asia.</p>                </td>
              </tr>
            <tr>
              <td align="center" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                  <tr>
                    <td width="79%">&nbsp;</td>
                    <td width="21%"><span class="default"><a href="#" onClick="javascript:window.open('pstClient.php','video','width=600,height=620,status=0,directories=no,scrollbars=0,resizable=0,left=100,top=100');">View our past clients list. </a></span></td>
                  </tr>
                </table>
                <p>
                  <iframe name=window src=List.php width=790 height=560 frameborder=0 scrolling=auto> </iframe></p>
                </td>
            </tr>
          </table></td>
        </tr>
      
    </table></td>
  </tr>

<tr>
  <td><!--DWLayoutEmptyCell-->&nbsp;</td>
</tr>
<tr>
  <td align="center" background="Images/bgRB.gif" bgcolor="#000000"><span class="footer">| &copy; Copyright   1998 - 2006 John Chacko Holdings Sdn. Bhd. | Last Updated on
      <!-- #BeginDate format:Am1m -->August 28, 2006  10:52<!-- #EndDate -->
|</span></td>
</tr>
</table>
</body>
</html>