Create New Variable In Post And Sort Category Template By That Variable

Here is part of the code where I believe the new code should be inserted:

<div id="main" class="clear">
			<div id="content">
				<?php while (have_posts()) : the_post(); ?>
					<h1 class="title"><?php the_title(); ?></h1>
					<div class="entry page">
						<?php if ( function_exists( 'add_theme_support' ) ) the_post_thumbnail( 'index-thumb', array( 'class' => 'single-post-thm alignright border' ) ); ?>
						<?php the_content(); ?>
						<?php edit_post_link(__( 'Edit', 'traction' )); ?>
						<?php wp_link_pages(); ?>
					</div><!--end entry-->

I am looking to use this code snippet but do not know where in there to put it and retain the while loop:

$querystr = "
			SELECT wposts.*
			FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta
			WHERE wposts.ID = wpostmeta.post_id
			AND wpostmeta.meta_key = 'date'
			AND wposts.post_status = 'publish'
			AND wposts.post_type = 'post'
			ORDER BY STR_TO_DATE(wpostmeta.meta_value, '%m/%d/%Y') ASC
			";

		$pageposts = $wpdb->get_results($querystr, OBJECT);

thank you, and where is that placed in the first code block?

and the date format needs to be 10/05/2011 or 20111005 or something else?

thank you very much by the way