Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <div class="cols1">
- <div class="left">
- <h2>Conference News</h2>
- <?php
- $get = mysql_query("SELECT * FROM wp_posts, wp_term_relationships WHERE wp_posts.id = wp_term_relationships.object_id ORDER BY post_date DESC;") or die("Mmm pie:" . mysql_error());
- $get_number = mysql_num_rows($get);
- if( $get_number > "0" ) {
- $count = 1;
- while ( $row = mysql_fetch_object($get) ) {
- if ($row->term_taxonomy_id == '3' && $count != 4) { ?>
- <h3><span><?php echo substr($row->post_date,0,10); ?> : </span> <a href="<?php echo $row->guid; ?>"><?php echo $row->post_title; ?></a></h3>
- <p><?php echo substr(strip_tags($row->post_content),0,100); ?>...</p>
- <?php
- $count++;
- }
- }
- } ?>
- </div>
- <div class="right">
- <h2>Industry News</h2>
- <?php
- $get = mysql_query("SELECT * FROM wp_posts, wp_term_relationships WHERE wp_posts.id = wp_term_relationships.object_id ORDER BY post_date DESC;") or die("Mmm pie:" . mysql_error());
- $get_number = mysql_num_rows($get);
- if( $get_number > "0" ) {
- $count = 1;
- while ( $row = mysql_fetch_object($get) ) {
- if ($row->term_taxonomy_id == '4' && $count != 4) { ?>
- <h3><span><?php echo substr($row->post_date,0,10); ?> : </span> <a href="<?php echo $row->guid; ?>"><?php echo $row->post_title; ?></a></h3>
- <p><?php echo substr(strip_tags($row->post_content),0,100); ?>...</p>
- <?php
- $count++;
- }
- }
- } ?>
- </div>
- </div>
- <div class="cols1">
- <div class="left">
- <h2>Upcoming Sessions</h2>
- <?php
- $get = mysql_query("SELECT * FROM wp_posts, wp_term_relationships WHERE wp_posts.id = wp_term_relationships.object_id ORDER BY post_date DESC;") or die("Mmm pie:" . mysql_error());
- $get_number = mysql_num_rows($get);
- if( $get_number > "0" ) {
- $count = 1;
- while ( $row = mysql_fetch_object($get) ) {
- if ($row->term_taxonomy_id == '5' && $count != 4) { ?>
- <h3><span><?php echo substr($row->post_date,0,10); ?> : </span> <a href="<?php echo $row->guid; ?>"><?php echo $row->post_title; ?></a></h3>
- <p><?php echo substr(strip_tags($row->post_content),0,100); ?>...</p>
- <?php
- $count++;
- }
- }
- } ?>
- </div>
- <div class="right">
- <h2>Specials</h2>
- <?php
- $get = mysql_query("SELECT * FROM wp_posts, wp_term_relationships WHERE wp_posts.id = wp_term_relationships.object_id ORDER BY post_date DESC;") or die("Mmm pie:" . mysql_error());
- $get_number = mysql_num_rows($get);
- if( $get_number > "0" ) {
- $count = 1;
- while ( $row = mysql_fetch_object($get) ) {
- if ($row->term_taxonomy_id == '6' && $count != 4) { ?>
- <h3><span><?php echo substr($row->post_date,0,10); ?> : </span> <a href="<?php echo $row->guid; ?>"><?php echo $row->post_title; ?></a></h3>
- <p><?php echo substr(strip_tags($row->post_content),0,100); ?>...</p>
- <?php
- $count++;
- }
- }
- } ?>
- </div>
- </div>
Add Comment
Please, Sign In to add comment