update doesnot work

[sandy1028]

Hi,

 

The below code doesnot update the db.

Please tell me where is the errror

 

 

$array = array('”' => '"',
                 '’' => '\\\'',
                 '“' => '"',
                 '‘' => '\\\''
                );


foreach ($array as $key => $array)
{
echo "The key is $key: the array value is $entities_array\n";

$sq= mysql_query( "UPDATE table_name SET field_name=REPLACE(field_name, '".$key."', '".$entities_array."') WHERE field_name like '%$key%'") ;
}

[Adam]

Have you tried using mysql_error() to see if there's an error returned from the query? I'm assuming you've switched the table and field names to post on here? Do you get any PHP errors? Are they disabled?

[dzelenika]

Why don't you echo $sq and execute it in Database directly to see what happens?

[sandy1028]

$sq= "UPDATE table_name SET field_name=REPLACE(field_name, '".$key."', '".$entities_array."') WHERE field_name like '%$key%'" ;
$result = mysql_query($sq, $db_connect) or die(mysql_error());

 

No error... Actually I program takes time to execute.

 

Is the iterating of array is wrong?

 

Only the values of ” is updated with ". and iterating is not entered for the second element in array

 

 

[dzelenika]

should be:

 

foreach ($array as $key => $value)

 

instead of:

 

foreach ($array as $key => $array)

 

Don't you see that using $array variable twice?

[sandy1028]

if I use the "$value", after the script execution prints the message "

Query was empty";

[Adam]

Where does $entities_array come from?

[sandy1028]

Sorry it a $array. It was a typo.

 

Even after removing $entities_array to $array, I get the message "Query is empty".

But the row exists in the db.

[Adam]

Paste your full code. I can only assume at some point you've made a typo or accidentally changed a var.

[sandy1028]

This is the full code

 

$array = array('”' => '"',
                 '’' => '\\\'',
                 '“' => '"',
                 '‘' => '\\\''
                );


foreach ($array as $key => $value)
{

$sql= "UPDATE table_name SET field_name=REPLACE(field_name, '".$key."', '".$value."') WHERE field_name like '%".$key."%'" ;
$result = mysql_query($sql, $db_connect) or die(mysql_error());
}