mysql的問題

看板PHP作者smallyou1988 (嘖嘖)時間16年前 (2009/04/27 00:44)推噓2(2推 0噓 5→)

留言7則, 2人參與討論串1/1

<?php include_once("MrhotelMysql.php"); session_start(); $company=$_SESSION["membername"]; if($_SESSION["membername"]==""||!isset($_SESSION["membername"]) ||$_SESSION["status"]!=0){ ?> <script language="JavaScript"> window.location="NotLog2.php"; </script> <? } ?> <? $select_db=@mysql_select_db("mrhotel"); if(!$select_db) die("連結失敗"); $sql_query="SELECT * FROM `ceodecision` WHERE `company`=".$company; $result=mysql_query($sql_query); if(!isset($result)){ $sql_query1="INSERT INTO `ceodecision` ( company, BorrowMoney, ReturnMoney, StockBonus, Insurance, Bonus, RoomPro, CustomerPro, FoodPro, MarketPro, RoomManager, CustomerManager, FoodManager, BasicSupplies, Substain, EquipInvest, Ad, Discount, RoomPrice, PeopleTrain, MarketResearch, ResearchAndDevelope) VALUES ('".$company."','".$_POST["BorrowMoney"]."','".$_POST["ReturnMoney"]."', '".$_POST["StockBonus"]."', '".$_POST["Insurance"]."','".$_POST["Bonus"]."','".$_POST["RoomPro"]."', '".$_POST["CustomerPro"]."', '".$_POST["FoodPro"]."','".$_POST["MarketPro"]."','".$_POST["RoomManager"]."', '".$_POST["CustomerManager"]."', '".$_POST["FoodManager"]."','".$_POST["BasicSupplies"]."', '".$_POST["Substain"]."','".$_POST["EquipInvest"]."', '".$_POST["Ad"]."','".$_POST["Discount"]."','".$_POST["RoomPrice"]."', '".$_POST["PeopleTrain"]."', '".$_POST["MarketResearch"]."', '".$_POST["ResearchAndDevelope"]."')"; $result1=mysql_query($sql_query1); //echo mysql_error(); 可以看錯在哪裡!!!! 好用XD //echo $result1; }else{ $sql_query2="UPDATE `ceodecision` SET BorrowMoney=".$_POST["BorrowMoney"].", ReturnMoney=".$_POST["ReturnMoney"].", StockBonus=".$_POST["StockBonus"].", Insurance=".$_POST["Insurance"].", Bonus=".$_POST["Bonus"].", RoomPro=".$_POST["RoomPro"].", CustomerPro=".$_POST["CustomerPro"].", FoodPro=".$_POST["FoodPro"].", MarketPro=".$_POST["MarketPro"].", RoomManager=".$_POST["RoomManager"].", CustomerManager=".$_POST["CustomerManager"].", FoodManager=".$_POST["FoodManager"].", BasicSupplies=".$_POST["BasicSupplies"].", Substain=".$_POST["Substain"].", EquipInvest=".$_POST["EquipInvest"].", Ad=".$_POST["Ad"].", Discount=".$_POST["Discount"].", RoomPrice=".$_POST["RoomPrice"].", PeopleTrain=".$_POST["PeopleTrain"].", MarketResearch=".$_POST["MarketResearch"].", ResearchAndDevelope=".$_POST["ResearchAndDevelope"]." WHERE `company`=".$_SESSION["membername"]; $result2=mysql_query($sql_query2); //echo $result2; } ?> ---------------------------------------------------------------------- 以上這一段是我要寫進資料庫的程式碼但是都寫不進去瀏覽時都沒有出錯但是就是寫不進去我用echo mysql_error();也沒有看見錯所以應該不會資料庫有問題中間兩大段我都檢查過了應該沒有打錯或者漏掉的地方所以我在想是不是哪個環節或者是邏輯有問題!!!!!!!! 請各位大大幫幫忙!!!! QQ -- ※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 220.139.185.116