Jump to content

Archived

This topic is now archived and is closed to further replies.

Tandem

updating

Recommended Posts

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.

Share this post


Link to post
Share on other sites
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:

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

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.