Update . . . Set . . . not working

[Timm]

I'm using the following code to update a MySQL database:

while ($row = mysql_fetch_array($sql_result)) {

$Field1 = $row["Field1"];
$Sequence = $row["Sequence"];

$Field1 = str_replace("Replace this", "With this", $Field1);

mysql_query("UPDATE Requests
SET Field1 = $Field1
WHERE Sequence = $Sequence");

Print $Field1 ?> <BR> <? Print $Sequence ?> <BR><BR> <?;
}

If the "Replace this" and "With this" parts of the str_replace function are numeric,

$Field1 = str_replace("123", "456", $Field1);

this code works fine and the fields in the MySQL database are updated.

If the "Replace this" and "With this" parts of the str_replace function are text, the $Field1 strings printed to the browser are updated, but the MySQL database is not.

Any ideas?

Thanks!

Timm

[Wien]

What the type of the field Field1 ?

[stolzyboy]

single quote your variables if they are text and make sure your field type is char or varchar

[Timm]

Thank you, stolzyboy. Single quoting the variables works!

Timm

[Timm]

Okay, I thought I was finished, but I found one more problem. When I use the following code to do a search and replace, all records but the last record that was previously updated are successfully updated. What do I need to do to get this last record to update, too?

while ($row = mysql_fetch_array($sql_result)) {
$SearchField1 = $row[$SearchField];
$Sequence = $row["Sequence"];
$SearchField2 = str_replace($SearchFor, $ReplaceWith, $SearchField1);
mysql_query("Update TableName
SET $SearchField = '$SearchField2'
WHERE Sequence = '$Sequence'");
}

Thanks!

Timm