Jump to content


Check out our Community Blogs

Register and join over 40,000 other developers!


Recent Status Updates

View All Updates

Photo
- - - - -

problem with mssql insert

mssql

  • Please log in to reply
7 replies to this topic

#1 DrorZeno

DrorZeno

    CC Lurker

  • Just Joined
  • Pip
  • 7 posts

Posted 13 January 2010 - 09:45 AM

hello everyone ,

i have problem with mssql , i was trying insert and it is not come in ,

this my code:

$p = "INSERT INTO FC_friends (IDuser,statusline) VALUES ('50', 'Dror')";


and i don't have error.
  • 0

#2 WingedPanther73

WingedPanther73

    A spammer's worst nightmare

  • Moderator
  • 17757 posts
  • Location:Upstate, South Carolina
  • Programming Language:C, C++, PL/SQL, Delphi/Object Pascal, Pascal, Transact-SQL, Others
  • Learning:Java, C#, PHP, JavaScript, Lisp, Fortran, Haskell, Others

Posted 13 January 2010 - 05:29 PM

What data types are IDuser and statusline?
  • 0

Programming is a branch of mathematics.
My CodeCall Blog | My Personal Blog

My MineCraft server site: http://banishedwings.enjin.com/


#3 DrorZeno

DrorZeno

    CC Lurker

  • Just Joined
  • Pip
  • 7 posts

Posted 14 January 2010 - 10:51 AM

this data types is IDuser = bigint , statusline = text
  • 0

#4 phpprogs

phpprogs

    CC Lurker

  • Just Joined
  • Pip
  • 1 posts

Posted 15 January 2010 - 12:02 AM

what message error from mysql?
  • 0

#5 DrorZeno

DrorZeno

    CC Lurker

  • Just Joined
  • Pip
  • 7 posts

Posted 15 January 2010 - 01:56 AM

The first thing I said I have no user with an error of anything.
  • 0

#6 Feral

Feral

    CC Addict

  • Just Joined
  • PipPipPipPipPip
  • 158 posts

Posted 15 January 2010 - 05:00 AM

How are you calling $p to insert into mysql are you using the standard mysql or are you using mysqli.

Are you using "or die(mysql_error())" or "die($mysqli->error)" to check for errors.

Post as much of your code as possible that pertains to the problem, it will help in finding the cause
  • 0

#7 WingedPanther73

WingedPanther73

    A spammer's worst nightmare

  • Moderator
  • 17757 posts
  • Location:Upstate, South Carolina
  • Programming Language:C, C++, PL/SQL, Delphi/Object Pascal, Pascal, Transact-SQL, Others
  • Learning:Java, C#, PHP, JavaScript, Lisp, Fortran, Haskell, Others

Posted 15 January 2010 - 08:20 AM

If IDUser is an int, you really shouldn't use quotes around 50.
  • 0

Programming is a branch of mathematics.
My CodeCall Blog | My Personal Blog

My MineCraft server site: http://banishedwings.enjin.com/


#8 DrorZeno

DrorZeno

    CC Lurker

  • Just Joined
  • Pip
  • 7 posts

Posted 15 January 2010 - 02:41 PM

Okay, I managed to solve Tbaih, thanks everyone.
  • 0





Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download