Return multiple Posts as single table
-
query_posts( array( 'post_type' => 'ts_result', 'meta_query' => array( array( 'key' => '_ts_student_class', 'value' => $exam_reg, 'compare' => '=' ), array( 'key' => '_ts_school_term', 'value' => $exam_term, ), array( 'key' => '_ts_school_year', 'value' => $exam_year, ) ), 'posts_per_page' => 100 ) ); ?> <?php if ( have_posts() ) : while ( have_posts() ) : the_post(); ?> <table style="border:1px solid black" cellpadding="1.5" cellspacing="5"> <style type="text/css" media="print"> table{ border-collapse:collapse; } </style> <tbody> <tr> <th><strong>NAME\SUBJECT</strong></th> <th><strong>English Studies</strong></th> <th align='center' ><strong>Mathematics</strong></th> <th align='center'><strong>CCA</strong></th> <th align='center'><strong>Yoruba Language</strong></th> <th align='center'><strong>French</strong></th> <th align='center'><strong>Business Education</strong></th> </tr> <?php $subject_english_studies_exam_total= get_post_meta( get_the_ID(),'_ts_subject_english_studies_exam_total',true ); $subject_maths_exam_total= get_post_meta( get_the_ID(),'_ts_subject_maths_exam_total',true ); $subject_creative_arts_exam_total= get_post_meta( get_the_ID(),'_ts_subject_creative_arts_exam_total',true ); $subject_yoruba_lang_exam_total= get_post_meta( get_the_ID(),'_ts_subject_yoruba_lang_exam_total',true ); $subject_french_exam_total= get_post_meta( get_the_ID(),'_ts_subject_french_exam_total',true ); $subject_business_edu_exam_total= get_post_meta( get_the_ID(),'_ts_subject_business_edu_exam_total',true ); ?> <tr> <td><?php the_title(); ?></td> <td><?php echo $subject_english_studies_exam_total ;?></td> <td><?php echo $subject_maths_exam_total ;?></td> <td><?php echo $subject_creative_arts_exam_total ;?></td> <td><?php echo $subject_yoruba_lang_exam_total ;?></td> <td><?php echo $subject_french_exam_total ;?></td> <td><?php echo $subject_business_edu_exam_total ;?></td> </tr> </tbody> </table>The code above returns each post as an individual table of its own.
Screenshot: (https://drive.google.com/open?id=0BzoS3oOkVoTtckFjbFpiQnB6aE0)
I want them returned as a single table,
with one table head and with each post as a row.
How do I go about that, thanks.
Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
The topic ‘Return multiple Posts as single table’ is closed to new replies.