Guest User

Untitled

a guest
Jan 22nd, 2018
49
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.74 KB | None | 0 0
  1. if(!isset($_GET['album_id'])) { die("Album Not Found!"); } else { $album_id = mysql_real_escape_string($_GET['album_id']); }
  2.  
  3. $sql = "SELECT * FROM `audio_albums` WHERE `album_id` = ".$album_id."";
  4. $qry = mysql_query($sql);
  5. $num = mysql_num_rows($qry);
  6.  
  7. if($num ==  1) {
  8.     // Fetch Array
  9.     $arr = mysql_fetch_array($qry);
  10.     // Assign Values
  11.     $album_name     = $arr['album_name'];
  12.     $album_name_seo = $arr['album_name_seo'];
  13.     $album_id       = $arr['album_id'];
  14.     // Fetch Songs
  15.     $sql2 = "SELECT audio_id,album_id,title FROM `audios` WHERE `album_id` = ".$album_id." AND `public_private` = 'public' AND `approved` = 'yes' LIMIT 0, 30 ";
  16.     $qry2 = mysql_query($sql2);
  17.     $arr2 = mysql_fetch_array($qry2);
  18.     print_r($arr2);
  19. } else {
  20.     echo "Album Not Found!";
  21. }
Add Comment
Please, Sign In to add comment