0) { $product_id = intval($_GET['pid']); } else { $product_id = 8; // 8 or proig by default } // GET PRODUCT ID END $query = "SELECT title, content, content_2, content_3, content_4, price_pack FROM products WHERE id = '$product_id'"; $result = mysql_query($query); $row = mysql_fetch_array($result); $item_title = removecrap($row['title']); $item_price = $row['price_pack']; $item_price_format = number_format($item_price, 2, '.',','); $item_link = strtolower(seoURL(removecrap($row['title']))).".php"; $item_image = checkSQLImg(1,$key,"_1.jpg","default_1.png","./files/products"); $item_content = stripslashes($row['content']); $item_content_2 = stripslashes($row['content_2']); $item_content_3 = stripslashes($row['content_3']); $item_content_4 = stripslashes($row['content_4']); $html_page_title = $item_title; $html_page_desc = $page_title; $html_page_keywords = $page_title; $breadcrumb_title = Products; $breadcrumb_href = WEB."products.php?cid=".$category_id; $breadcrumb_2_title = $category_title; $breadcrumb_2_href = WEB."products.php?cid=".$category_id; $breadcrumb_3_title = $page_title; $breadcrumb_3_href = WEB."product.php?id=".$page_id; $subheader_bg = $product_id."_sub_header.jpg"; $query = " SELECT a.id AS id, a.title AS title, a.content AS content FROM products AS a WHERE a.id != '{$product_id}' AND a.domain_id = 2 AND a.status = '1' AND a.deleted = '0' ORDER BY rand(), a.create_date DESC LIMIT 4 "; $result = mysql_query($query); $rowcount = mysql_num_rows($result); if ($rowcount > 0) { $other_products_array = array(); while ($row = mysql_fetch_array($result)) { $other_products_array[] = $row; } mysql_free_result($result); // Release from memory - row } ?>