'artists', 'limit' => '1', 'where' => "title = '$artistname1'", 'allowSearch' => '0', )); return $artist; //print_r($artist); } list($albumsRecords, $albumsMetaData) = getRecords(array( 'tableName' => 'albums', 'where' => whereRecordNumberInUrl(1), 'limit' => '1', )); $albumsRecord = @$albumsRecords[0]; // get first record //print_r($albumsRecord); // show error message if no matching record is found if (!$albumsRecord) { header("HTTP/1.0 404 Not Found"); print "Record not found!"; exit; } list($musicnewsRecords, $featuredartistMetaData) = getRecords(array( 'tableName' => 'news', 'limit' => '3', 'where' => "catNews LIKE '%news%' AND catNews LIKE '%entertainment%'", 'orderBy' => 'publishDate DESC', 'allowSearch' => '0', )); function getCountrytitle($num) { // $query = 'title = '.$num; list($countryRecords, $countryMetaData) = getRecords(array( 'tableName' => 'country', 'where' => "title='$num'", 'limit' => '0', )); return $countryRecords[1]; } function getTracktitle($num) { list($tracktitle) = getRecords(array( 'tableName' => 'tracks', 'limit' => '1', 'where' => "num = '$num'", 'allowSearch' => '0', )); if(!empty($tracktitle)) { return $tracktitle[0]; } } function getyear($num) { list($yeartitle) = getRecords(array( 'tableName' => 'year2', 'limit' => '1', 'where' => "num = '$num'", 'allowSearch' => '0', )); if(!empty($yeartitle)) { return $yeartitle[0]; } } //echo whereRecordNumberInUrl(1); $num=$albumsRecord['num']; $art_search1 = "artists like '%".$albumsRecord['artists']."%'" ; list($otheralbumsRecords, $otheralbumsMetaData) = getRecords(array( 'tableName' => 'albums', 'where' => $art_search1."AND num != '$num'", 'limit' => '5', )); $art_search = "artists like '%".$albumsRecord['artists']."%'" ; list($relatedTracks, $relatedMetaData) = getRecords(array( 'tableName' => 'tracks', 'limit' => '10', 'where' => $art_search, 'orderBy' => 'date DESC', 'allowSearch' => '0', )); list($newsRecords, $newsMetaData) = getRecords(array( 'tableName' => 'news', 'where' => $art_search, 'limit' => '5', )); list($galleryRecords, $galleryMetaData) = getRecords(array( 'tableName' => 'gallery', 'limit' => '3', 'orderBy' => 'date DESC', 'allowSearch' => '0', )); function getImage($id) { $query = 'num = '.$id; list($imagesRecords, $imagesMetaData) = getRecords(array( 'tableName' => 'images', 'where' => $query, 'limit' => '1', )); //print_r($imagesRecords[0]['image'][0]['filePath']); return $imagesRecords; } //echo $artistname; ?> www.socanews.com | Music | <?php echo $albumsRecord['title']; ?>
   
   
 
home | music | albums |           
 

Year
Producer
 
albums
No Other Albums
<?php echo $otheralbumsRecords[0]['artists'] ?>
 
advertisement

   
advertisement
Music News
<?php echo $radiostations['title']; ?>