[Resolved] Bug in update script

[jakeone]

Hello

I'm trying to clean up some database records (datatype longtext). I ran the following and it cleaned all but 5 of my records.

For some reason, the following doesn't work when "We have many many" appears in its own paragraph, i.e. preceded by whitespace/new line.

Can anyone tell me what I'm doing wrong?

$sqlDesc = "SELECT vacID, vacDesc FROM ls_vacancies_backup2 WHERE vacDesc LIKE '%We have many many%'";
$resDesc = mysql_query($sqlDesc);
while ($qryDesc = mysql_fetch_assoc($resDesc))
{
$cleanPos = strpos($qryDesc['vacDesc'], "We have many many");
$cleanDesc = substr($qryDesc['vacDesc'], 0, $cleanPos);

$sqlUpdate = "UPDATE ls_vacancies_backup2 SET vacDesc = '$cleanDesc' WHERE vacID = ".$qryDesc['vacID'];
$resUpdate = mysql_query($sqlUpdate);
}

Thanks

[jakeone]

Silly mistake. Had not escaped the necessary characters in the field. Fixed it with

while ($qryDesc = mysql_fetch_assoc($resDesc))
{
$cleanPos = strpos($qryDesc['vacDesc'], "We have many many");
$cleanDesc = substr($qryDesc['vacDesc'], 0, $cleanPos);
$cleanDesc = htmlspecialchars($cleanDesc);

$sqlUpdate = "UPDATE ls_vacancies SET vacDesc = \"$cleanDesc\" WHERE vacID = ".$qryDesc['vacID'];
$resUpdate = mysql_query($sqlUpdate);
}