<?php
	require_once('admin.php');
	//___________________________________________
	$Display->Title = 'Askme';
	$Display->Subtitle = 'Manage answers';
	//______________________________________________
	require ('./admin-display-header.php');
	
	//Database queries---------------------
	$Question = $DC->Result("SELECT * FROM ".PR_DATABASE_PREFIX."askme WHERE askme_status = 'answered'");
	//-------------------------------------
	print " <h2> Manage your answers &raquo; </h2> <hr />";
	if($Question == false) $Collect = ' <p> no published answers <a href="./askme-new.php">Answer new questions.</a></p> ';
	else
	{
		foreach($Question as $key => $KeyValue)
		{
			if(empty($i)) $i = 0;
			if($i%2 == 0) $BackgroundColour = '#F1F1F1';
			else $BackgroundColour = '#E2E2E2';
			$i++;
?>
<div style='background-color:<?php _P($BackgroundColour); ?>; padding:8px; margin:4px; border:solid 1px grey;'>
<strong>Asked-by:</strong> <?php _P($KeyValue['askme_asker_name']); ?>
|| <strong>URL:</strong> <a href='<?php _P($KeyValue['askme_asker_url']); ?>'><?php _P($KeyValue['askme_asker_url']); ?></a>
|| <strong>E-mail:</strong> <a href='mailto:<?php _P($KeyValue['askme_asker_mail']); ?>'><?php _P($KeyValue['askme_asker_mail']); ?></a>
|| <strong>Time:</strong> <?php _p($KeyValue['askme_question_time']); ?>

<dl>
	<dt> <strong>Question:</strong> </dt>
	<dd> <blockquote style="font-family:Georgia, 'Times New Roman', Times, serif; text-indent:10px;"> <?php _P($KeyValue['askme_question']); ?> </blockquote> </dd>
</dl>
	
<dl>
	<dt> <strong>Your Answer:</strong> </dt>
	<dd> <blockquote style="font-family:Georgia, 'Times New Roman', Times, serif; text-indent:10px;"> <?php _P($KeyValue['askme_answer']); ?> </blockquote> </dd>
</dl>
<a href='./askme-edit.php?id=<?php _p($KeyValue['askme_id']); ?>'> Edit Answer </a> || 
<a href='./askme-edit-update.php?action=delete&id=<?php _P($KeyValue['askme_id']); ?>'>Delete this question</a>
</div>
<?php
		}
	}
	
require('./admin-display-footer.php');
?>