"") $que = "select * from products prd where writer_e = '". get("auth") ."' and prod_active=1 order by prod_seq,writer_e, prod_name"; if ($sword <> "") { $addque = " where prod_store=$StoreId and (prod_code like '%" . $sword . "%'"; $addque = $addque . " OR prod_name_e like '%" . $sword . "%'"; $addque = $addque . " OR prod_name like '%" . $sword . "%'"; $addque = $addque . " OR prod_ISBN like '%" . $sword . "%'"; //$addque= $addque . " OR prod_publisher like '%" . $sword . "%'"; $addque = $addque . " OR writer_e like '%" . $sword . "%')"; if ($lang !="") $addque .= " and prod_type='$lang'"; //$addque = $addque . " OR prod_year like '%" . $sword . "%' or prod_publisher like '%" . $sword . "%' or prod_ISBN like '%" . $sword . "%' or prod_name_e like '%" . $sword . "%' or writer_e like '%" . $sword . "%'"; if ($prod_cat != "") $addque = $addque . " and prod_cat= '". $prod_cat."' "; $que="select * from products prd " . $addque . " and prod_active=1 order by prod_seq, writer_e, prod_name"; } //echo $que; $disp = "none"; $result = mysql_query($que); $total_books = mysql_num_rows($result); $total_groups= ceil($total_books/$items_per_group); $total_groups; //$total_groups= ceil($total_books/$items_per_group); // $View_Class="layout-list"; //if ($View=="G") $View_Class="row add-clearfix"; ?>