get & display custom field data from child pages in table

Here’s an example to play with – replace the get_post_custom with your c2c…code.

<?php
//in page, get children of this page and display with custom field 'cf1'
$parent_id = $posts[0]->ID;
$args=array(
  'post_parent' => $parent_id,
  'post_type' => 'page',
  'post_status' => 'publish',
  'posts_per_page' => -1,
  'caller_get_posts'=> 1
);
$my_query = null;
$my_query = new WP_Query($args);
if( $my_query->have_posts() ) {
  echo 'List of Posts';
  while ($my_query->have_posts()) : $my_query->the_post(); ?>
    <p><a href="<?php the_permalink() ?>" rel="bookmark" title="Permanent Link to <?php the_title_attribute(); ?>"><?php the_title(); ?></a></p>
    <?php
    $meta = get_post_meta($post->ID, 'cf1', true);
    if ($meta){
      echo 'customfield1: '. $meta;
    }
  endwhile;
}
wp_reset_query();  // Restore global post data stomped by the_post().
?>

Thanks, Michael, I found another post after I first posted that also included your above code… and have been trying to modify it to work… but no joy… it worked, but there was no data… hmmm, somethings wonky.

THEN I realized that what I want is the child pages of another page… for example, the page I am displaying this all on is ‘Program Partners’ which has the id of ‘301’. It has some child pages:
Partner Organizations (A-Z) (323)
Partners by Service Category (324)

I want to get the custom field data from Partner Organizations, 9which is 323) to display the meta keys of ‘Org-Name’ and ‘Service-Categories’ using the c2c function so I can put html tags before, after, between, after last, etc for each child page.

I’m thinking I have to run the main loop and display that page’s content, etc… following it by an <?php endwhile; ?>

Then… run a new query for p=323 and use something like <?php get_pages(‘arguments’); ?> to display/echo those custom field values.

Then, I’d follow it with endwhile; and before the get_footer(), use an endif;

But I keep getting a parsing error – Parse error: syntax error, unexpected T_ENDWHILE in[blahblah]

Here’s what I am using for both loops, starting from my main content div (mc) and ending the page where I get my footer:

<div id="mc">

<?php if (have_posts()) : ?>
<?php while (have_posts()) : the_post(); ?>
<div class="post mpi" id="post-<?php the_ID(); ?>">
<h2 class="toptitle"><?php the_title(); ?></h2>
<?php the_content(); ?>

<p class="postmetadata"><?php edit_post_link('Edit this content ↑', '', ''); ?></p>

</div>

<?php endwhile; ?>

<table class="spreadsheet"><tr>
<th>Organization Name</th>
<th>Education</th>
<th>Public Safety</th>
<th>Youth Development</th>
<th>Family Support</th>
<th>Health</th>
<th>Financial Independence & Community Economic Development</th>
</tr>
<?php $my_query = new WP_Query('p=323');
$args = array(
'child_of' => 323,
'parent' => 323,
'sort_order' => 'ASC',
'sort_column' => 'post_title',
'hierarchical' => 0
); ?>
<?php
  $pages = get_pages('child_of=323&parent=323&sort_column=post_title&sort_order=ASC&hierarchical=0');
  foreach ($pages as $page) {
echo c2c_get_custom('Org-Name','<tr><th>','</th>','','');
echo c2c_get_custom('Service-Categories','<tr><td>','</td>',' ','</td><td>','</td></tr>'); }
?>
<?php endwhile; ?>
</table>
<!--THIS IS THE TABBED AREA OF THE SITE -->
<?php include (TEMPLATEPATH . '/tabbercontent.php'); ?>

<?php endif; ?>

</div>
<?php get_footer(); ?>

Totally off base? Suggestions?

THEN I realized that what I want is the child pages of another page

You are likely going to need to use c2c_get_post_custom to get your custom field where $page->ID should be the $post_id value:

<?php function c2c_get_post_custom( $post_id, $field, $before='', $after='', $none='', $between='', $before_last='' ) ?>

Thank you SO much! I hadn’t thought to look within Scott’s plugins for a solution.

I’ll post back when and if I get it to work.