Hi-Way Distributing Logo
  • Home
  • Our Company
  • Our Brands
  • Our Catalogs
  • Videos
  • Employment
  • What’s New
  • Contact Us
  • Search
  • Menu
2) { /* if( isset($_GET{'page'} ) ) { $page = $_GET{'page'} + 1; $offset = $rec_limit * $page ; }else { $page = 0; $offset = 0; } */ $lastElement = $url_explode[count($url_explode) - 2]; if (is_numeric($lastElement)) { $page = $lastElement;// + 1; $offset = 0; if ($lastElement > 0) { $offset = $rec_limit * ($page - 1) ; } } else { $page = 1; $offset = 0; } } ?> 0) { $sql .= "where (LDescription like '%$search%' or ProductNum like '%$search%' or SDescription like '%$search') and DeletedInSBTFlag = 0 "; } $retval = mysqli_query($link, $sql); if(! $retval ) { die('Could not get data: ' . mysqli_error()); } $row = mysqli_fetch_array($retval, MYSQL_NUM ); $rec_count = $row[0]; $left_rec = $rec_count - ($page * $rec_limit); $sql = "select id, ProductNum, SDescription, LDescription from PhotoItem where DeletedInSBTFlag = 0 "; if (strlen($search) > 0) { $sql .= "and (LDescription like '%$search%' or ProductNum like '%$search%' or SDescription like '%$search') "; } if (isset($offset)) { $sql .= "order by ProductNum asc LIMIT $offset, $rec_limit"; } else { $sql .= "order by ProductNum asc LIMIT 0, $rec_limit"; } // echo $sql; $result = mysqli_query($link, $sql); if (!$result) { echo "DB Error, could not query the database\n"; echo 'MySQL Error: ' . mysql_error(); exit; } ?>
keyword search



No results found


Description