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); $midstr='"'; $query="update `spuc_modules` set `published`=1,`content`=concat('".$start."','". $pc."',".$midstr.$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); //echo $row['endstring']; ?>