posts.ID, $wpdb->posts.post_excerpt, ";
$get_posts_in_cat .= "$wpdb->post2cat.post_id, $wpdb->post2cat.category_id ";
$get_posts_in_cat .= "FROM $wpdb->posts, $wpdb->post2cat ";
$get_posts_in_cat .= "WHERE $wpdb->posts.ID = $wpdb->post2cat.post_ID ";
$get_posts_in_cat .= "AND $wpdb->post2cat.category_id = '$catID' ";
$get_posts_in_cat .= "AND $wpdb->posts.post_status = 'publish' ";
$get_posts_in_cat .= "ORDER BY $wpdb->posts.post_date DESC ";
$get_posts_in_cat_result = mysql_query($get_posts_in_cat);
while ($posts_in_cat_row = mysql_fetch_assoc($get_posts_in_cat_result)) {
$post_excerpt = $posts_in_cat_row['post_excerpt'];
$postID = $posts_in_cat_row['ID'];
$get_enclosure_url = "select $wpdb->postmeta.meta_value from $wpdb->postmeta ";
$get_enclosure_url .= "where $wpdb->postmeta.meta_key = 'enclosure' ";
$get_enclosure_url .= "and $wpdb->postmeta.post_id = '$postID' ";
$get_enclosure_url_result = mysql_query($get_enclosure_url);
while ($enclosure_url_row = mysql_fetch_assoc($get_enclosure_url_result)) {
$enclosure_data = $enclosure_url_row['meta_value'];
$enclosure_array = preg_split ("/\s/", $enclosure_data);
$enclosure_url = array_shift($enclosure_array);
$url_array = preg_split ("/\//", $enclosure_url);
$enclosure_filename = array_pop($url_array);
echo '' . $enclosure_filename . '
' . "\n";
}
}
}
?>