posts.* FROM $wpdb->posts WHERE $wpdb->posts.post_status = 'publish' AND $wpdb->posts.post_type = 'page' AND $wpdb->posts.post_parent = '68' ORDER BY $wpdb->posts.post_title ASC"; $pageposts = $wpdb->get_results($querystr, OBJECT); if ($pageposts) { foreach ($pageposts as $post) { $custom_fields = get_post_custom($post->ID); $my_custom_field = $custom_fields['des']; ?>


'.$my_custom_field[0].'
'; } } else { echo 'Not Found'; } ?>