[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;
}
$initStartLimit = 0;
$limitPerPage = 10;
$startLimit = $_REQUEST[‘startLimit’];
$numberOfRows = $_REQUEST[‘rows’];
$sortBy = $_REQUEST[‘sortBy’];
$sortOrder = $_REQUEST[‘sortOrder’];
$albumName = $_GET[‘id’];
//$albumName = ‘Ultra’;
if ($startLimit==””)
{
$startLimit = $initStartLimit;
}
if ($numberOfRows==””)
{
$numberOfRows = $limitPerPage;
}
if ($sortOrder==””)
{
$sortOrder = “DESC”;
}
if ($sortOrder == “DESC”) { $newSortOrder = “ASC”; } else { $newSortOrder = “DESC”; }
$limitQuery = ” LIMIT “.$startLimit.”,”.$numberOfRows;
$nextStartLimit = $startLimit + $limitPerPage;
$previousStartLimit = $startLimit – $limitPerPage;
if ($sortBy!=””)
{
$orderByQuery = ” ORDER BY “.$sortBy.” “.$sortOrder;
}
$sql1 = “SELECT * FROM songtekst WHERE cd = ‘$albumName’ ORDER BY cdnummer”;
$result1 = MYSQL_QUERY($sql1);
//$sql2 = “SELECT * FROM songtekst WHERE cd = ‘$albumName’ AND cdnummer in (2, 4, 6, 8, 10, 12, 14, 16, 18, 20)”;
//$result2 = MYSQL_QUERY($sql2);
$sql3 = “SELECT nummer FROM songtekst WHERE cd = ‘$albumName’ ORDER BY cdnummer”;
$result3 = MYSQL_QUERY($sql3)or die(mysql_error());
//$numberOfRows = MYSQL_NUM_ROWS($result1);
//$numberOfRows2 = MYSQL_NUM_ROWS($result2);
$numberOfRows3 = MYSQL_NUM_ROWS($res3);
if ($numberOfRows==0) {
?>
} else if ($numberOfRows>0) {
$i=0;
?>
echo $albumName ?> |
---|
while ($i<$numberOfRows) { if (($i%2)==0) { $bgColor = "#FFFFFF"; } else { $bgColor = "#333333"; } $thisCd1 = MYSQL_RESULT($result1,$i,"cd"); $thisNummer1 = MYSQL_RESULT($result1,$i,"nummer"); $thisSongtekst1 = MYSQL_RESULT($result1,$i,"songtekst"); $thisCd2 = @MYSQL_RESULT($result2,"cd"); $thisNummer2 = @MYSQL_RESULT($result2,$i,"nummer"); $thisSongtekst2 = @MYSQL_RESULT($result2,$i,"songtekst"); $thisCd3 = @MYSQL_RESULT($result3,"cd"); $thisNummer3 = @MYSQL_RESULT($result3,$i,"nummer"); $thisSongtekst3 = @MYSQL_RESULT($result3,$i,"songtekst"); ?>
echo stripslashes($thisSongtekst1); ?>
$i++; } // end while loop ?>
} // end of if numberOfRows > 0
// Free resultset
mysql_free_result($result3);
[/insert_php]