tender_recover_wait`=`tender_recover_wait`+,
+ 后面是什么?

解决方案 »

  1.   

    貌似是这段:borrowCountClass::UpdateBorrowCount(array("user_id"=>$tender_userid,"borrow_nid"=>"{$borrow_result['borrow_nid']}","nid"=>$tender_nid,"tender_success_times"=>1,"tender_success_account"=>$tender_account,"tender_frost_account"=>-$tender_account,"tender_recover_account"=>$recover_all,"tender_recover_wait"=>$recover_all,"tender_capital_account"=>$recover_capital_all,"tender_capital_wait"=>$recover_capital_all,"tender_interest_account"=>$recover_interest_all,"tender_interest_wait"=>$recover_interest_all,"tender_recover_times"=>$recover_times,"tender_recover_times_wait"=>$recover_times));
      

  2.   

    别瞎猜!
    MySQL server version for the right syntax to use near '`tender_recover_wait`=`tender_recover_wait`+,`tender_capital_account`=`tender_ca' at line 1
    就是 Mysql 认为有错的地方
      

  3.   

    `tender_recover_wait`=`tender_recover_wait`+,
    加什么呢?
      

  4.   

    update `wangdai_borrow_count` set user_id='337',`tender_success_times`=`tender_success_times`+1,`tender_success_account`=`tender_success_account`+2000.00,`tender_frost_account`=`tender_frost_account`+-2000,`tender_recover_account`=`tender_recover_account`+,`tender_recover_wait`=`tender_recover_wait`+,`tender_capital_account`=`tender_capital_account`+,`tender_capital_wait`=`tender_capital_wait`+,`tender_interest_account`=`tender_interest_account`+,`tender_interest_wait`=`tender_interest_wait`+,`tender_recover_times`=`tender_recover_times`+1,`tender_recover_times_wait`=`tender_recover_times_wait`+1 where user_id='337'
      

  5.   

    '`tender_recover_wait`=`tender_recover_wait`+,`tender_capital_account`=`tender_ca' 
    這樣寫能不錯嗎。。那個+後面應該有東西的。update `wangdai_borrow_count` set user_id='337',`tender_success_times`=`tender_success_times`+1,`tender_success_account`=`tender_success_account`+2000.00,`tender_frost_account`=`tender_frost_account`+-2000,`tender_recover_account`=`tender_recover_account`+?,`tender_recover_wait`=`tender_recover_wait`+?,`tender_capital_account`=`tender_capital_account`+?,`tender_capital_wait`=`tender_capital_wait`+?,`tender_interest_account`=`tender_interest_account`+?,`tender_interest_wait`=`tender_interest_wait`+?,`tender_recover_times`=`tender_recover_times`+1,`tender_recover_times_wait`=`tender_recover_times_wait`+1 where user_id='337'?的地方是需要有東西的,你都沒有,當然錯了。填上就好了。
    另外你where user_id=337 ,那麼update時就沒有必要set user_id=337了。