Could not connect to mysql. It seems MySQL is not running or cannot be connected due to technical issue. Please contact administrator';
exit;
}
else if (!mysql_select_db($database, $link)) {
echo 'MySQL is now connected but could not select database. Please contact administrator';
exit;
}
$sc="";
$search="";
if(isset($_GET["pr"]) && $_GET["pr"]<>"")
$sc=" form LIKE '%" . $_GET["pr"] . "%' ";
$search="";
if(isset($_POST["sstring"]) && $_POST["sstring"]<>"")
$search=" name1 LIKE '%" . $_POST["sstring"] . "%' OR name2 LIKE '%" . $_POST["sstring"] . "%' OR speciality LIKE '%" . $_POST["sstring"] . "%'";
if($sc<>"")
$sc=" WHERE " . $sc;
else if($search<>"")
$search = " WHERE " . $search;
if($sc<>"" && $search<>"")
$search = " AND (" . $search . ")";
$addedCondition="";
if(($sc<>"" || $search<>"") && (!isset($_GET["type"])))
$addedCondition = " AND idproduct > -1 ";
else
$addedCondition = " WHERE idproduct > -1 ";
if(isset($_GET["type"])) {
if($_GET["type"]=="newarrival")
$addedCondition = $addedCondition . " AND newarrival='Yes'";
else if($_GET["type"]=="featured")
$addedCondition = $addedCondition . " AND featured='Yes'";
}
if(isset($_GET["brand"]))
$addedCondition = $addedCondition . " AND brand='" . $_GET["brand"] . "' ";
$query="SELECT SQL_CALC_FOUND_ROWS trim(name1) as name1, trim(name2) as name2, packing FROM product " . $sc . $search . $addedCondition . " ORDER BY name1 ASC";
//echo $query;
$resultSet = mysql_query($query);
$res=mysql_fetch_array(mysql_query("SELECT FOUND_ROWS() as count"));
$totalRecords = $res['count'];
?>
0) {
$count=1;
$sstring="";
if(isset($_POST["sstring"]))
$sstring=$_POST["sstring"];
echo '
';
}
?>