[RESOLVED] Php Error while using update function on Mysql DB

[desi]

Hello,
I had to change my domain name but the problem is that my host phpmyadmin is broken so I wrote a php script to do the job of search and replace for lots of changes and I was able to do that except I got stuck when I excecute this particular code to replace src=" which I badly want to do.. Parse error: syntax error, unexpected T_STRING in /home/guessity/public_html/videos/replace.php on line 6 error while executing a particular function -

<?php
// Connects to your Database
mysql_connect("localhost", "guessity_d", "desi") or die(mysql_error());
mysql_select_db("guessity_d") or die(mysql_error());

$update = "UPDATE node_revisions SET body = replace(body, 'src="http://www.domain.com', 'src="http://www.anotherdomain.com');";
mysql_query($update);
""
?>

I would be happy if someone can tell where I have gone wrong.

[halojoy]

How about this.

Might work:

<?php
// Connects to your Database
mysql_connect("localhost", "guessity_d", "desi") or die(mysql_error());
mysql_select_db("guessity_d") or die(mysql_error());

$update = "UPDATE node_revisions SET body = '" 
. replace(body, 'src="http://www.domain.com"', 'src="http://www.anotherdomain.com"') 
. "'";
mysql_query($update);

?>

[desi]

I now get error saying --

Fatal error: Call to undefined function: replace() in /home/guessity/public_html/videos/replace.php on line 6

[laserlight]

I think halojoy misunderstood what you were trying to do. You could try:

$update = "UPDATE node_revisions SET body = replace(body, 'src=\"http://www.domain.com', 'src=\"http://www.anotherdomain.com');";

[desi]

Works perfect. Thanks laserlight. 🙂

[laserlight]

You're welcome 🙂
Remember to mark this thread as resolved using the thread tools.