Tour Dates
setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
$sth = $dbh-> prepare ($SQL);
$sth->execute();
$sth->setFetchMode(PDO::FETCH_OBJ);
while($row = $sth->fetch()) {
$band = $row->tour_title;
$band2 = $row->twitter;
$patterns[0] = '/ /';
$patterns[1] = '/\'/';
$patterns[2] = '/\//';
$patterns[3] = '/$/';
$patterns[4] = '/@/';
$patterns[5] = '/\?/';
$patterns[6] = '/\"/';
$patterns[7] = '/\,/';
$patterns[8] = '/\)/';
$patterns[9] = '/\(/';
$patterns[10] = '/&/';
$patterns[11] = '/!/';
$replacements[0] = '+';
$replacements[1] = '';
$replacements[2] = '+';
$replacements[3] = '';
$replacements[4] = '';
$replacements[5] = '';
$replacements[6] = '';
$replacements[7] = '';
$replacements[8] = '';
$replacements[9] = '';
$replacements[10] = 'and';
$replacements[11] = '';
$newband = preg_replace($patterns, $replacements, $band);
$newband2 = preg_replace($patterns, $replacements, $band2);
?>
getMessage ();
} ?>