Hi All,
i got this
Unknown system variable 'companies_registered'
message when i execute the page.
this is where i have 'companies_registered' in the source codes
'companies_registered' is a table name for a table in the mysql database.
i have no idea how this happened, please help, thanks~
i got this
Unknown system variable 'companies_registered'
message when i execute the page.
this is where i have 'companies_registered' in the source codes
PHP Code:
$c_name = $row_User['c_name'];
$c_reg = $row_User['c_reg'];
$update_score_sql = "SET companies_registered (bee_rating, o_score, sr_score, ee_score,";
$update_score_sql .= " sd_score, pp_score, ed_score, si_score, ind_spec_score) VALUES";
$update_score_sql .= " ('$total_bee_score', '$ownership_score', '$sr_score', '$ee_score',";
$update_score_sql .= " '$sd_score', '$pp_score', '$ed_score', '$si_score', '$ind_spec_score')";
$update_score_sql .= " WHERE tbc_product_serial = '$v_serials'";
$insert_score_sql = "INSERT INTO companies_registered VALUES ('$total_bee_score',";
$insert_score_sql .= " '$ownership_score', '$sr_score', '$ee_score', '$sd_score', '$pp_score',";
$insert_score_sql .= " '$ed_score', '$si_score', '$ind_spec_score', '$c_name', '$c_reg',";
$insert_score_sql .= " '$v_serials')";
mysql_select_db($database_MySQL, $MySQL);
$query_list = "SELECT * FROM companies_registered WHERE tbc_product_serial = '$v_serials'";
if (mysql_query($query_list, $MySQL)){
$update_result = mysql_query($update_score_sql) or die(mysql_error());
echo "Your BEE Score have been updated";
}
else{
$update_result = mysql_query($insert_score_sql) or die(mysql_error());
echo "Your BEE Score have been uploaded";
}
i have no idea how this happened, please help, thanks~
Comment