<% //Header("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); //Header("Pragma : no-cache"); //Header("Cache-control: no-cache"); //$date_modif=gmdate("D, d M Y H:i:s"); //Header("Last-Modified: $date_modif GMT"); //include 'session.php3'; //$language_id= $Session['language_id']; //$country_id= $Session['country_id']; //$distributor_id= $Session['distributor_id']; $language_id= "1"; $country_id= "1"; $distributor_id= "1"; $topic_id = "1"; if ($date == "") { $date = $Session['date']; } //$Session['date'] = "$date"; //Session_Save(); $hostname = "localhost"; $password = ""; $user = "www"; $database = "prosveta01"; mysql_pconnect($hostname,$user,$password) or die("Unable to connect to SQL server"); mysql_select_db("$database") or die("Unable to select database"); $result = mysql_query("Select translation_text From translations Where translation_name = 'distributor' And translation_language_id = '$language_id'"); while ($row = mysql_fetch_row($result)) { $distributor = mysql_result($result,$row[translation_text]); } %> <% $result = mysql_query("SELECT * FROM product_topic WHERE topic_id = $topic_id"); echo "
"; echo ""; $foo=1; while ($row = mysql_fetch_array($result)) { $product_id = $row[product_id]; $product_order = $row[product_order]; $result_products = mysql_query("SELECT * FROM products WHERE product_id = $product_id"); while ($row = mysql_fetch_array($result_products)) { echo "\n"; } $foo++; } echo "\n"; echo "
$row[product_reference]$row[product_title]\n"; echo ""; echo "
"; echo "
"; %>