The Golf Dome - thegolfdome.ca

display_price($results['products_price']); $product_info_query2 = tep_db_query("SELECT products_name FROM products_description WHERE products_id=\"$first_product_id\""); $results2=tep_db_fetch_array($product_info_query2); // product price $first_product_name = $results2[products_name]; // product info page $first_product_url = "http://www.thegolfdome.ca/product_info.php?products_id=" . $first_product_id; // get 3rd product info $products = tep_db_fetch_array($products_query); // $third_product_id = $products['products_id']; $third_product_id = 662; $product_info_query = tep_db_query("SELECT products_price, products_mediumimage FROM products WHERE products_id=\"$third_product_id\""); $results=tep_db_fetch_array($product_info_query); // product image $third_product_image = $results[products_mediumimage]; // product price // $third_product_price = $results[products_price]; $third_product_price = $currencies->display_price($results['products_price']); $products_id_query = tep_db_query("select * from products_to_categories where categories_id=32 LIMIT 1"); $products_ids = tep_db_fetch_array($products_id_query); $cur_product_id = $products_ids['products_id']; // show this product $cur_product_id = 133; $products_query = tep_db_query("SELECT products_id FROM products_description where products_id =\"$cur_product_id\" LIMIT 1"); // get 2nd product info $products = tep_db_fetch_array($products_query); // $second_product_id = $products['products_id']; $second_product_id = 136; $product_info_query = tep_db_query("SELECT products_price, products_mediumimage FROM products WHERE products_id=\"$second_product_id\""); $results=tep_db_fetch_array($product_info_query); // product image $second_product_image = $results[products_mediumimage]; // product price // $second_product_price = $results[products_price]; $second_product_price = $currencies->display_price($results['products_price']); $product_info_query2 = tep_db_query("SELECT products_name FROM products_description WHERE products_id=\"$second_product_id\""); $results2=tep_db_fetch_array($product_info_query2); // product price $second_product_name = $results2[products_name]; // product info page $second_product_url = "http://www.thegolfdome.ca/product_info.php?products_id=" . $second_product_id; // change price acco // what is this? $product_info_query2 = tep_db_query("SELECT products_name FROM products_description WHERE products_id=\"$third_product_id\""); $results2=tep_db_fetch_array($product_info_query2); // product price $third_product_name = $results2[products_name]; // product info page $third_product_url = "http://www.thegolfdome.ca/product_info.php?products_id=" . $third_product_id; ?>