BROWSER == "Netscape") { $in_size = "7"; } else { $in_size = "14"; } ?> " ; echo "" ; echo "" ; echo "" ; echo "
Forms " alt="current news" title="current news"> " alt="sort by date" title="sort by date"> " alt="sort by artist" title="sort by artist"> " alt="sort by topic" title="sort by topic"> join newslist remove from list

 

" ; echo "
"; if($select=="date") { include "news_date.inc" ; } if($select=="artist") { include "news_artist.inc" ; } if($select=="topic") { include "news_topic.inc" ; } echo "
" ; $maxrow = 4 ; if($select==1) { $query = "SELECT * FROM promo_news LEFT JOIN promo_artist ON promo_artist.artist=promo_news.artist "; $query = "$query WHERE published='#$show'" ; $result = mysql_query($query) ; $num = mysql_numrows($result) ; page($stop,$num,$a_page,$show,$select,$start,$title) ; } if($select==2) { $query = "SELECT * FROM promo_news LEFT JOIN promo_artist ON promo_artist.artist=$show "; $query = "$query WHERE (promo_news.artist=$show) " ; $query = "$query ORDER BY promo_news.published DESC" ; $result = mysql_query($query) ; $num = mysql_numrows($result) ; $i=0 ; $name = mysql_result($result,$i,"promo_artist.name") ; $title = $name; page($stop,$num,$a_page,$show,$select,$start,$title) ; } if($select==3) { $query = "SELECT * FROM promo_news LEFT JOIN promo_artist ON promo_artist.artist=promo_news.artist "; $query = "$query WHERE type='$show' ORDER BY promo_news.published DESC" ; $result = mysql_query($query) ; $num = mysql_numrows($result) ; $title = strtoupper($show); page($stop,$num,$a_page,$show,$select,$start,$title) ; } ?>

 

= '".$now."'" ; $result = mysql_query($query) ; $num = mysql_numrows($result) ; $i=0; echo "" ; while($i<$num) { $id = mysql_result($result,$i,"promo_news.id") ; $catno = mysql_result($result,$i,"artist") ; $company = mysql_result($result,$i,"company") ; $published = mysql_result($result,$i,"published") ; $type = mysql_result($result,$i,"type") ; $cover = mysql_result($result,$i,"cover") ; $news = ereg_replace("\n","
",mysql_result($result,$i,"news")) ; //$album = mysql_result($result,$i,"promo_products.title") ;*/ //$orgdat = mysql_result($result,$i,"promo_products.release") ;*/ //$month = substr($orgdat,5,2) ; //$year = substr($orgdat,0,4) ; //$day = substr($orgdat,8,2) ; //$release = date("jS of F Y",mktime(0,0,0,$month,$day,$year)); $name = mysql_result($result,$i,"promo_artist.name") ; /*$label = mysql_result($result,$i,"promo_label.name") ;*/ echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; $i++; } echo "
$name" ; echo "
 

" ; // echo imgtype($id,$cover,$type) ; echo "
$news

" ; echo ""; /*if($type=="release") { echo " 
" ; if($orgdat!="") { echo "release date: $release
" ; } echo "(current album "$album" - $label)" ; }*/ echo " 

 

" ; } /** AUSGABE DATUM **/ if($select==1) { echo "" ; $i = $start ; if($stop>=$num) { $stop=$num ; } while($i<$stop) { $id = mysql_result($result,$i,"promo_news.id") ; $catno = mysql_result($result,$i,"artist") ; $company = mysql_result($result,$i,"company") ; $published = mysql_result($result,$i,"published") ; $type = mysql_result($result,$i,"type") ; $cover = mysql_result($result,$i,"cover") ; $news = ereg_replace("\n","
",mysql_result($result,$i,"news")) ; //$album = mysql_result($result,$i,"promo_products.title") ; //$orgdat = mysql_result($result,$i,"promo_products.release") ;*/ //$month = substr($orgdat,5,2) ; //$year = substr($orgdat,0,4) ; //$day = substr($orgdat,8,2) ; //$release = date("jS of F Y",mktime(0,0,0,$month,$day,$year)); $name = mysql_result($result,$i,"promo_artist.name") ; //$label = mysql_result($result,$i,"promo_label.name") ;*/ echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; $i++; } echo "
$name" ; echo "
 

" ; if($type == 'release') { $link = "" ; $tag = "hspace=\"2\" vspace=\"4\" align=\"right\" border=\"1\"" ; $pic = $cover ; $alt = "Artwork" ; $dir = $dir_cover; } else { $link = "" ; $tag = "hspace=\"8\" vspace=\"4\" align=\"right\" border=\"1\"" ; $pic = "news_$id" ; $alt = "Image" ; $dir = "images/"; } if(picture($dir,$pic,$alt,$link,$tag)) { echo $image; } echo "$news

" ; echo ""; /*if($type=="release") { echo " 
" ; if($orgdat!="") { echo "release date: $release
" ; } echo "(current album "$album" - $label)" ; }*/ echo " 

 

" ; } /** AUSGABE BAND **/ if($select==2) { echo "" ; $i = $start ; if($stop>=$num) { $stop=$num ; } while($i<$stop) { $id = mysql_result($result,$i,"promo_news.id") ; $catno = mysql_result($result,$i,"artist") ; $company = mysql_result($result,$i,"company") ; $orgdat1 = mysql_result($result,$i,"published") ; $month = substr($orgdat1,5,2) ; $year = substr($orgdat1,0,4) ; $published = date("F Y",mktime(0,0,0,$month,1,$year)); $type = mysql_result($result,$i,"type") ; $cover = mysql_result($result,$i,"cover") ; $news = ereg_replace("\n","
",mysql_result($result,$i,"news")) ; //$album = mysql_result($result,$i,"promo_products.title") ; //$orgdat = mysql_result($result,$i,"promo_products.release") ; //$month = substr($orgdat,5,2) ; //$year = substr($orgdat,0,4) ; //$day = substr($orgdat,8,2) ; //$release = date("jS of F Y",mktime(0,0,0,$month,$day,$year)); $name = mysql_result($result,$i,"promo_artist.name") ; //$label = mysql_result($result,$i,"promo_label.name") ;*/ echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; $i++; } echo "
$published" ; echo "
 

" ; $link = "" ; $tag = "hspace=\"8\" vspace=\"4\" align=\"right\" border=\"1\"" ; if($type == 'release') { $pic = $cover ; $alt = "Artwork" ; $dir = $dir_cover; } else { $pic = "news_$id" ; $alt = "Image" ; $dir = "images/"; } if(picture($dir,$pic,$alt,$link,$tag)) { echo $image; } echo "$news

" ; echo ""; /*if($type=="release") { echo " 
" ; if($orgdat!="") { echo "release date: $release
" ; } echo "(current album "$album" - $label)" ; }*/ echo " 

 

" ; } /** AUSGABE TOPIC **/ if($select==3) { echo "" ; $i = $start ; if($stop>=$num) { $stop=$num ; } while($i<$stop) { $id = mysql_result($result,$i,"promo_news.id") ; $catno = mysql_result($result,$i,"artist") ; $company = mysql_result($result,$i,"company") ; $orgdat1 = mysql_result($result,$i,"published") ; $month = substr($orgdat1,5,2) ; $year = substr($orgdat1,0,4) ; $published = date("F Y",mktime(0,0,0,$month,1,$year)); $type = mysql_result($result,$i,"type") ; $cover = mysql_result($result,$i,"cover") ; $news = ereg_replace("\n","
",mysql_result($result,$i,"news")) ; /*$album = mysql_result($result,$i,"promo_products.title") ; $orgdat = mysql_result($result,$i,"promo_products.release") ; $month = substr($orgdat,5,2) ; $year = substr($orgdat,0,4) ; $day = substr($orgdat,8,2) ; $release = date("jS of F Y",mktime(0,0,0,$month,$day,$year));*/ $name = mysql_result($result,$i,"promo_artist.name") ; /*$label = mysql_result($result,$i,"promo_label.name") ;*/ echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; $i++; } echo "
" ; if($show!="label") { echo "$name" ; } echo "
 

" ; $link = "" ; $tag = "hspace=\"8\" vspace=\"4\" align=\"right\" border=\"1\"" ; if($type == 'release') { $pic = $cover ; $alt = "Artwork" ; $dir = $dir_cover; } else { $pic = "news_$id" ; $alt = "Image" ; $dir = "images/"; } if(picture($dir,$pic,$alt,$link,$tag)) { echo $image; } echo "$news

" ; echo ""; echo "

(published $published)" ; echo " 

 

" ; } ?>