{source} setQuery($textquery); $row = $db->loadAssoc(); $start=$row['startString']; $end=$row['endstring']; $pc='AB15+9QJ'; //$query="update `spuc_modules` set `published`=1,`content`= concat($start,$pc,$end) where `id`=223"; //The Following querystring is the correct syntax for adding the Postcode only: //$query="update `spuc_modules` set `published`=1,`content`="."'"."'". $pc."'"." where `id`=223"; //$start=htmlspecialchars($start); //$end=htmlspecialchars($end); $query="update `spuc_modules` set `published`=1,`content`=concat('".$start."','". $pc."',".$end.") where `id`=223"; //update `spuc_modules` set `published`=1,`content`=concat('
)' where `id`=223 //$pc=$_GET["postcode"]; //$pc='AB15 8QJ'; //$pc= str_replace(' ','+',$pc); //$query=$q1.'\''.$pc.'\''.$q2.$qwhere; // print_r($row); $db->setQuery($query); $db->query(); //echo htmlspecialchars($query); ?> {/source}