Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if(!isset($_GET['album_id'])) { die("Album Not Found!"); } else { $album_id = mysql_real_escape_string($_GET['album_id']); }
- $sql = "SELECT * FROM `audio_albums` WHERE `album_id` = ".$album_id."";
- $qry = mysql_query($sql);
- $num = mysql_num_rows($qry);
- if($num == 1) {
- // Fetch Array
- $arr = mysql_fetch_array($qry);
- // Assign Values
- $album_name = $arr['album_name'];
- $album_name_seo = $arr['album_name_seo'];
- $album_id = $arr['album_id'];
- // Fetch Songs
- $sql2 = "SELECT audio_id,album_id,title FROM `audios` WHERE `album_id` = ".$album_id." AND `public_private` = 'public' AND `approved` = 'yes' LIMIT 0, 30 ";
- $qry2 = mysql_query($sql2);
- $arr2 = mysql_fetch_array($qry2);
- print_r($arr2);
- } else {
- echo "Album Not Found!";
- }
Add Comment
Please, Sign In to add comment