fetchRow(MDB2_FETCHMODE_ASSOC)) { $f = normalize($row['ppl_forename']); $p = normalize($row['ppl_prefix']); $s = normalize($row['ppl_surname']); if ($p == '') $n = $f.' '.$s; else $n = $f.' '.$p.' '.$s; //echo($row['ppl_id'].' '.$n.'
'); //print_r($row); mdb2_exec($db, "UPDATE ppl SET ppl_name_normalized = '%q', ppl_forename_normalized = '%q', ppl_prefix_normalized = '%q', ppl_surname_normalized = '%q' WHERE ppl_id = {$row['ppl_id']}", $n, $f, $p, $s); } header('Location: index.php'); ?>