$limit){ $x = strip_tags($text); $text = substr(trim($x),0,$limit)."..."; }else{ $text = trim($text); } return $text; } $sqlBasket = "SELECT `tbl_basket`.`basket_id` AS `basket_id`,`tbl_basket`.`inquiry_no` AS `inquiry_no`,`tbl_basket`.`sid` AS `sid`,`tbl_basket`.`product_id` AS `product_id`,`tbl_basket`.`size_id` AS `size_id`,`tbl_basket`.`size_name` AS `size_name`,`tbl_basket`.`color_id` AS `color_id`,`tbl_basket`.`color_name` AS `color_name`,`tbl_basket`.`qty` AS `qty`,`tbl_basket`.`price` AS `price`,`tbl_basket`.`logged` AS `logged`,`tbl_items`.`ItmName` AS `ItmName`,`tbl_items`.`ArtNo` AS `ArtNo`,`tbl_items`.`ItmImg` AS `ItmImg`,`tbl_items`.`ItmlImg` AS `ItmlImg` FROM (`tbl_basket` JOIN `tbl_items` ON ((`tbl_basket`.`product_id` = `tbl_items`.`ItmID` and sid = '".$sId."' AND inquiry_no = 0 )))"; $bgcolor = "#9f9f9f"; $category = $_REQUEST["category"].""; $section = $_REQUEST["section"].""; $id = $_REQUEST["id"].""; $pname = $_REQUEST["product"].""; if (trim($id)!=""){ $strId = explode("-",$id); if (trim($strId[0])=="2"){ $flash = "casual.swf"; }else{ $flash = "sports.swf"; } } $page = $_REQUEST["page"].""; if (trim($page)==""){ $page = 1; } $br = ""; $no_product = "We Are Updating Our Products."; $no_basket = "Your Inquiry Basket Is Empty."; $ref = $_SERVER['HTTP_REFERER'].""; function MainSectionIMG($mainid){ global $connect; $qry = mysql_query($connect,"SELECT * FROM tbl_mainsection WHERE RecID = $mainid"); if (mysqli_num_rows($qry)){ $fld = mysqli_fetch_array($qry); $return = $fld["file1"].""; }else{ $return = ""; } mysqli_free_result($qry); return $return; } function MainSectionR($mainid){ global $connect; $qry = mysqli_query($connect,"SELECT * FROM tbl_mainsection WHERE RecID = $mainid"); if (mysqli_num_rows($qry)){ $fld = mysqli_fetch_array($qry); $return = $fld["MSecName"].""; }else{ $return = ""; } mysqli_free_result($qry); return $return; } function MainSection($mainid){ global $connect; $qry = mysqli_query($connect,"SELECT * FROM tbl_mainsection WHERE MSecID = $mainid"); if (mysqli_num_rows($qry)){ $fld = mysqli_fetch_array($qry); $return = $fld["MSecName"].""; }else{ $return = ""; } mysqli_free_result($qry); return $return; } function Section($secid){ global $connect; $qry = mysqli_query($connect,"SELECT * FROM tbl_section WHERE SecID = $secid"); if (mysqli_num_rows($qry)){ $fld = mysqli_fetch_array($qry); $return = $fld["SecName"].""; }else{ $return = ""; } mysqli_free_result($qry); return $return; } function first_link(){ global $connect; $qry = mysqli_query($connect,"SELECT * FROM tbl_mainsection ORDER BY Rank LIMIT 0,1"); if (mysqli_num_rows($qry)>0){ $fld = mysqli_fetch_array($qry); $m = $fld["MSecID"]; $qry2 = mysqli_query($connect,"SELECT * FROM tbl_section WHERE MSecID = $m ORDER BY Rank LIMIT 0,1"); if (mysqli_num_rows($qry2)>0){ $fld2 = mysqli_fetch_array($qry2); $s = $fld2["SecID"]; }else{ $s = 0; } mysqli_free_result($qry2); }else{ $m = 0; } mysqli_free_result($qry); return $m."-".$s."-0-0"; } require_once("inc/cnlink.php"); ?>