Songtekst

[insert_php]

if (!$link = mysql_connect(‘rdbms.strato.de’, ‘U2773866’, ‘IrvYSUDmBbjrF52pr’)) {
echo ‘Could not connect to mysql’;
exit;
}

if (!mysql_select_db(‘DB2773866’, $link)) {
echo ‘Could not select database’;
exit;
}

function highlightSearchTerms($fullText, $searchTerm, $bgcolor=”#FFFFFF”)
{
if (empty($searchTerm))
{
return $fullText;
}
else
{
$start_tag = ““;
$end_tag = ““;
$highlighted_results = $start_tag . $searchTerm . $end_tag;
return eregi_replace($searchTerm, $highlighted_results, $fullText);
}
}

$thisKeyword = $_REQUEST[‘keyword’];

$sqlQuery = “SELECT * FROM songtekst WHERE songtekst like ‘%$thisKeyword%’ OR nummer like ‘%$thisKeyword%'”;
$result = MYSQL_QUERY($sqlQuery);
$numberOfRows = MYSQL_NUM_ROWS($result);

if ($numberOfRows==0) {
?>

if ($numberOfRows==0) {
OpenTable(0);
?>

– klik hier voor een overzicht van alle albums
0) {
OpenTable(0);
?>