php with sql help

[kabar916]

Whats going on you guys.  i cant figure out how to use the UPDATE function in php to update a field in sql.  I basically want to remove all the quote symbol ( " ) in a certain field.  This is what how i wrote it.  please let me know where im making the error.

 

<?php

require_once("includes/connection.php");

$result = mysql_query("UPDATE export SET department = REPLACE(department, '\"\','  ')", $connection)

?>

[MarPlo]

Hi,

I think it's a problem with a slash, try this:

$result = mysql_query("UPDATE export SET department = REPLACE(department, '". '"'. "','  ')", $connection);

[Muddy_Funster]

You only have 1 slash too many, but you need an extra set of parenthesis around the whole REPLACE statement:

$result = mysql_query("UPDATE export SET department = (REPLACE(department, '\"',' '))", $connection);

[kabar916]

Thanks for the help.  that solved that problem.  do you know how to remove the qoutes sign in the hold table or do i have to do one field at a time

[Muddy_Funster]

you could put it in a loop:

$qry = "SHOW COLUMS FROM export";
$loop_result = mysql_query($sql) or die (mysql_error());
$c= 0;
while ($loop_row = mysql_fetch_array($loop_result)){
$field = $loop_row['Field'];
$sql = "UPDATE export SET $field = (REPLACE(department, '\"',' '))";
$update = mysql_query($sql) or die (mysql_error());
$c = $c++;
}
if($c >= 1){
echo "$c Fileds have been successfuly reformated";
}
else{
echo "Operation did not update any rows";
}

[kabar916]

thanks a lot bro.  you saved a lot of work.