--- index.php 2001/06/07 06:06:05 1.8 +++ index.php 2001/06/21 09:59:50 1.9 @@ -3,6 +3,7 @@ $auth = true; if ($auth && (!isset($PHP_AUTH_USER) || !isset($PHP_AUTH_PW))) $auth = false; + if ($change) { $id = $new_id; $edit = false; } if ($auth) { include("conn.php"); DBOpen(); @@ -61,7 +62,7 @@ } if ($save) { $error = ""; - $q = array(); + $q = array("cas_no='$cas_no'"); if ($error == "" && $ok_market > 0) { if (!CheckURL($info_market)) { $error = "Invalid URL."; $err = 1; } if ($error == "") array_push($q, "link_market='$info_market',cust_existing='$cust_existing',cust_potential='$cust_potential',fc_price='$fc_price'"); @@ -139,7 +140,7 @@ } if ($error == "") $msg = true; else $edit = 1; } else { - $row = DBQuery("SELECT link_market,link_production,link_purchasing,link_economics,link_risks,link_competition,link_potential,link_quality,link_dosage,link_sales,comment,cust_potential,cust_existing,fc_price,competitors,holders,market_size,quality,registrations,last_fda,cap_nominal,cap_util,ther_class,indication,sales_1999,launch_year,mat_raw,suppliers,mat_cost,fc_rank,fc_share,maturity,comp_intensity,comp_position,cogs,op_income,break_even,m3,sales_img,risks FROM products WHERE (product_id=$id)"); + $row = DBQuery("SELECT link_market,link_production,link_purchasing,link_economics,link_risks,link_competition,link_potential,link_quality,link_dosage,link_sales,comment,cust_potential,cust_existing,fc_price,competitors,holders,market_size,quality,registrations,last_fda,cap_nominal,cap_util,ther_class,indication,sales_1999,launch_year,mat_raw,suppliers,mat_cost,fc_rank,fc_share,maturity,comp_intensity,comp_position,cogs,op_income,break_even,m3,sales_img,risks,cas_no FROM products WHERE (product_id=$id)"); if (count($row) <= 0) { echo "No such product ID."; exit; } list($info_market, $info_production, $info_purchasing, $info_economics, $info_risks, $info_competition, @@ -151,7 +152,7 @@ $launch_year, $mat_raw, $suppliers, $mat_cost, $fc_rank, $fc_share, $maturity, $comp_intensity, $comp_position, $cogs, $op_income, $break_even, - $m3, $sales_img, $risks) = $row[0]; + $m3, $sales_img, $risks, $cas_no) = $row[0]; } $row = DBQuery("SELECT naziv FROM products WHERE (product_id=$id)"); list($product_name) = $row[0]; @@ -187,14 +188,14 @@ +
- + - - - +?> - - +
FINE CHEMICALS
\\1", $product_name); ?>

CAS No:
CAS No:
PRODUCT MATRIX
product to 		 
product to 		Date of last change:
Date of last change:
@@ -386,13 +385,14 @@
   Logged in as .  [Logout]   Logged in as .  [Logout]  
- + +