Buying need help with php & mssql query fast !!

Discussion in 'Programming' started by Shimurai, Dec 12, 2011.

  1. #1
    hi,

    I am trying to run this query:
    
    $userid = 'testusern';
    $password = 'somepassword';
    $ddate = date('m/d/Y');
    $activationid = md5($userid);
    
    
    mssql_query("INSERT INTO MEMB_INFO (memb___id,memb__pwd,memb_name,sno__numb,bloc_code,ctl1_code,mail_chek,mail_addr,appl_days,modi_days,out__days,true_days,SecretQuestion,SecretAnswer,Country,Gender,confirmed,activation_id) 
    VALUES ($userid,[dbo].[fn_md5]($password,$userid),$userid,'test','111111111111''0','0','1','blabla@gmail.com',$ddate,$ddate,'2005-01-03','2005-01-03','2','someanswer','1','1','1',$activationid)");
    
    PHP:
    and I am getting the following message:
    
    Warning: mssql_query() [function.mssql-query]: message: The name "testusern" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted. (severity 15) in PATHTOFILE on line 13
    
    Warning: mssql_query() [function.mssql-query]: Query failed in PATHTOFILE on line 13
    
    Code (markup):

    Why ??

    I will pay $15 usd to the person who can help me get this query done !
     
    Shimurai, Dec 12, 2011 IP
  2. zappak

    zappak Active Member

    Messages:
    366
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    80
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #2
    sent you p-m..
     
    zappak, Dec 12, 2011 IP
  3. Shimurai

    Shimurai Well-Known Member

    Messages:
    186
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    110
    As Seller:
    100% - 2
    As Buyer:
    100% - 0
    #3
    issue has been solved !
     
    Shimurai, Dec 12, 2011 IP