Jump to content


Photo

updating


  • Please log in to reply
2 replies to this topic

#1 Tandem

Tandem
  • Members
  • PipPipPip
  • Advanced Member
  • 251 posts

Posted 30 September 2006 - 11:23 PM

I just moved my site to a new server, and i'm having a couple of MySQL problems.

Whenever i try to update a record of TEXT type with a long string of text, via mysql_query(), especially one with a lot of new lines in it, it just doesn't update. It appears to work fine via phpmyadmin.

Anyone have any ideas as to why this might be happening?

Thanks.

#2 AndyB

AndyB
  • Staff Alumni
  • Advanced Member
  • 5,465 posts
  • LocationToronto

Posted 30 September 2006 - 11:57 PM

It's an error with your coded query.  You could post a few relevant lines of your code, or trap and display the error which may well tell you excatly how to solve the problem.  Code like this works for me:

$query = "UPDATE tablename ..... etc.";
$result = mysql_query($query) or die("Error: ". mysql_error(). " with query ". $query);

Legend has it that reading the manual never killed anyone.
My site

#3 Tandem

Tandem
  • Members
  • PipPipPip
  • Advanced Member
  • 251 posts

Posted 01 October 2006 - 01:10 PM

I found out why. I was using apostrophes in the things that i was trying to update the database with, and i wasn't adding slashes.

Funny how it was never a problem with the old server.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users