Hi Kafkaesqui,
WOW! You are such a kind soul to invest so much time and energy to help… I appreciate your efforts so very much!
You have given me several paths to pursue now that I know the “standard” query works for you…
My comments template is attached at the bottom of this post. I am using the “paged-comments” plugin which is fantastic and really needed in my usage (guestbook)… I have the appropriate ‘echo’ statement stuffed into the template without formatting just to see if it will display… No luck… I also added the php ‘echo’ to the standard WP comment template without success…
I am going to spend my time chasing the DB error referred to in my previous post. My suspicion is that my template and the php ‘echo’ call are correct, but the DB is failing to join the new table appropriately and therefore none of the records in the new _extra table can be echo’d…
Your kindness has warmed my heart on this cold day…
Thanks!
———–
‘ <?php // Do not delete these lines
if (‘comments-paged.php’ == basename($_SERVER[‘SCRIPT_FILENAME’]))
die (‘Please do not load this page directly. Thanks!’);
if (!empty($post->post_password)) { // if there’s a password
if ($_COOKIE[‘wp-postpass_’ . COOKIEHASH] != $post->post_password) { // and it doesn’t match the cookie
?>
<p class=”nocomments”>This post is password protected. Enter the password to view comments.<p>
<?php
return;
}
}
/* This variable is for alternating comment background */
$oddcomment = ‘alt’;
?>
<!– You can start editing here. –>
<h3 id=”respond”>Add Your Well Wishes Here:</h3>
<?php if ( get_option(‘comment_registration’) && !$user_ID ) : ?>
<p>You must be /wp-login.php?redirect_to=<?php the_permalink(); ?>”>logged in to post a comment.</p>
<?php else : ?>
<form action=”<?php echo get_option(‘siteurl’); ?>/wp-comments-post.php” method=”post” id=”commentform”>
<?php if ( $user_ID ) : ?>
<p>Logged in as /wp-admin/profile.php”><?php echo $user_identity; ?>. /wp-login.php?action=logout” title=”Log out of this account”>Logout »</p>
<?php else : ?>
<p><input type=”text” name=”author” id=”author” value=”<?php echo $comment_author; ?>” size=”22″ tabindex=”1″ />
<label for=”author”><small>Name <?php if ($req) echo “(required)”; ?></small></label></p>
<p><input type=”text” name=”email” id=”email” value=”<?php echo $comment_author_email; ?>” size=”22″ tabindex=”2″ />
<label for=”email”><small>E-Mail (will not be published) <?php if ($req) echo “(required)”; ?></small></label></p>
<p><input type=”text” name=”url” id=”url” value=”<?php echo $comment_author_url; ?>” size=”22″ tabindex=”3″ />
<label for=”url”><small>Your Website URL</small></label></p>
<p><input type=”text” name=”commentcity” id=”commentcity” value=”<?php echo $comment_extra_commentcity; ?>” size=”22″ tabindex=”4″ />
<label for=”commentcity”><small>Your City</small></label></p>
<p><input type=”text” name=”commentstate” id=”commentstate” value=”<?php echo $comment_extra_commentstate; ?>” size=”22″ tabindex=”5″ />
<label for=”commentstate”><small>Your State</small></label></p>
<p><input type=”text” name=”commentcountry” id=”commentcountry” value=”<?php echo $comment_extra_commentcountry; ?>” size=”22″ tabindex=”6″ />
<label for=”commentstate”><small>Your Country</small></label></p>
<?php endif; ?>
<p><textarea name=”comment” id=”comment” cols=”40%” rows=”8″ tabindex=”7″></textarea></p>
<p><input name=”submit” type=”submit” id=”submit” tabindex=”8″ value=”Send a Wish” />
<input type=”hidden” name=”comment_post_ID” value=”<?php echo $id; ?>” />
</p>
<?php do_action(‘comment_form’, $post->ID); ?>
</form>
<?php endif; // If registration required and not logged in ?>
<?php if ($comments) : ?>
<h3 id=”comments”><?php comments_number(‘No Wishes Yet:’, ‘Only One Wish:’, ‘% Wishes so far:’ );?> </h3>
<!– Comment page numbers –>
<?php if ($paged_comments->pager->num_pages() > 1): ?>
<p class=”comment-page-numbers”><?php _e(“Pages:”); ?> <?php paged_comments_print_pages(); ?></p>
<?php endif; ?>
<!– End comment page numbers –>
<ol class=”commentlist” style=”list-style-type: none;”>
<?php foreach ($comments as $comment) : ?>
<li class=”<?php echo $oddcomment; ?>” id=”comment-<?php comment_ID() ?>”>
<div class=”comment-number”>Wish# <?php echo $comment_number; $comment_number += $comment_delta;?></div>
<cite><?php comment_author_link() ?></cite> Says:
<?php if ($comment->comment_approved == ‘0’) : ?>
Your comment is awaiting moderation.
<?php endif; ?>
<small class=”commentmetadata”>” title=””><?php comment_date(‘F jS, Y’) ?> at <?php comment_time() ?> <?php edit_comment_link(‘e’,”,”); ?>
<?php echo $comment->extra_commentcity; ?></small>
<?php comment_text() ?>
<?php /* Changes every other comment to a different class */
if (‘alt’ == $oddcomment) $oddcomment = ”;
else $oddcomment = ‘alt’
?>
<?php endforeach; /* end for each comment */ ?>
<!– Comment page numbers –>
<?php if ($paged_comments->pager->num_pages() > 1): ?>
<p class=”comment-page-numbers”><?php _e(“Pages:”); ?> <?php paged_comments_print_pages(); ?></p>
<?php endif; ?>
<!– End comment page numbers –>
<?php else : // this is displayed if there are no comments so far ?>
<?php if (‘open’ == $post->comment_status) : ?>
<!– If comments are open, but there are no comments. –>
<?php else : // comments are closed ?>
<!– If comments are closed. –>
<p class=”nocomments”>Comments are closed.</p>
<?php endif; ?>
<?php endif; ?>
<?php if (‘open’ == $post->comment_status) : ?>
<?php endif; // if you delete this the sky will fall on your head ?> ‘
