Warning: mssql_query(): message: Syntax error converting datetime from character string. (severity 16) in rejestracja2.php on line 172

  1. <?php
  2.  }
  3.  
  4.  if(!$page["register_after_validation"] OR !$page["validate_by_email"])
  5. {
  6. addtolog("<b>REG: $login $pw</b>","REG");
  7. mssql_query("INSERT INTO VI_CURR_INFO (ends_days,chek_code,used_time,memb___id,memb_name,memb_guid,sno__numb,Bill_
    Section,Bill_value,Bill_Hour,Surplus_Point,Surplus_Minute,Increase_Days) VALUES ('20055','1',1234,'$login','$login',1,'7','6','3','6','6',getdate(),'0' )"
    ) or die('erorek bledorek biggrin.gif');
  8. mssql_query("SET IDENTITY_INSERT MEMB_INFO ON INSERT INTO MEMB_INFO (memb_guid,memb___id,memb__pwd,memb_name,sno__numb,post_code,addr_info,addr_
    d
  9. eta,tel__numb,mail_addr,phon_numb,fpas_ques,fpas_answ,job__code,appl_days,modi_d
  10. ays,out__days,true_days,mail_chek,bloc_code,ctl1_code) VALUES ('1','$login','$pw','$name', '1','1234','11111','personalid','12343','$email','$email','$prq','$pra','1',getdate(),getdate(),getdate(),getdate(),'1','0','1')") or die('error, query failed');
  11. echo $lang_acc_done;
  12. }
  13.  else
  14. {
  15. mail($_POST['email'], $nazwa.$lang_email_title, sprintf($lang_email_content_2,$login,$nazwa,$mail_hash), $naglowki);
  16. mssql_query("INSERT INTO ST_EMAIL (AccountID,EMail,Fine,hash) values('$login','$email',0,'$mail_hash',".date('U').")");
  17.  
  18.  
  19. ?>

questionmark.gif