.title { color:white; background-color:black; } .red { color:white; background-color:red; } .green { color:white; background-color:green; } EOT; echo ""; foreach ($changes as $key => $change) { echo ""; echo ""; echo ""; echo ""; echo ""; $query_sql="SELECT filepath,pid,filename FROM {$CONFIG['TABLE_PICTURES']} WHERE filepath LIKE '%{$change[0]}%'"; $results=cpg_db_query($query_sql); echo ""; echo ""; echo ""; echo ""; echo ""; while ($row = mysql_fetch_assoc($results)) { $row['filepath']=addslashes(str_replace($change[0],$change[1],$row['filepath'])); $update_sql="UPDATE {$CONFIG['TABLE_PICTURES']} SET filepath='{$row['filepath']}' WHERE pid='{$row['pid']}' LIMIT 1"; $update_results=cpg_db_query($update_sql); if ($update_results) { $class="green"; } else { $class="red"; } echo ""; echo ""; echo ""; echo ""; echo ""; } } echo "

Key: $key	From: {$change[0]}	To: {$change[1]}
pid	filepath	filename
{$row["pid"]}	{$row["filepath"]}	{$row["filename"]}

"; pagefooter(); ob_end_flush(); ?>