--- index.php 2001/06/06 10:54:22 1.7 +++ index.php 2001/06/21 10:07:13 1.11 @@ -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]; @@ -168,7 +169,7 @@ if ($old_netscape) echo "\n"; else echo "\n"; ?> -