// include header include("inc_header.php"); // initialize parameter variables $p_page = init_param("p_page", "1"); $p_itm_type = init_param("p_itm_type", "weddings"); // initialize sql fields $l_sql_fields = ("*"); // initialize sql tables $l_sql_tables = ("items"); // initialize sql where expression $l_sql_where_exp = ("(type = '".$p_itm_type."')"); $l_sql_where = ("WHERE (".$l_sql_where_exp.")"); // initialize sql order $l_sql_order = (" ORDER BY sku ASC"); // construct sql to retrieve the requested records $l_sql = ("SELECT ".$l_sql_fields." FROM ".$l_sql_tables." ".$l_sql_where." ".$l_sql_order); // retrieve the requested records $rs_itm = mysqli_query($g_db_connection, $l_sql); // get number of records to display $l_recs = mysqli_num_rows($rs_itm); // initialize page variables $l_page_size = (6); $l_pages = ceil($l_recs / $l_page_size); ?>
// include footer include("inc_footer.php"); ?>