Location: PHPKode > projects > Prsaar Social Networking Platform > PrsaarColour-0.7.alpha.6.3/pr-admin/askme-new.php
<?php
	require_once('admin.php');
	//__________________________________________________________
	$Display->Title = 'Askme';
	$Display->Subtitle = 'New questions';
	//___________________________________________________________
	require('./admin-display-header.php');
	
	//Database queries---------------------
	$Question = $DC->Result("SELECT * FROM ".PR_DATABASE_PREFIX."askme WHERE askme_status = 'toanswer'");
	//-------------------------------------
	
	print  " <h2> Answer new questions &raquo;&raquo; </h2> ";
		
	if($Question == false) print ' <p> no new questions <a href="./askme-answer.php">Manage your question/answers</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>Time:</strong> <?php _P($KeyValue['askme_question_time']); ?>
		|| <strong>E-mail:</strong> <a href='mailto:<?php _P($KeyValue['askme_asker_mail']); ?>'> <?php _P($KeyValue['askme_asker_mail']); ?></a>
	
	<dl>
		<dt> Question </dt>
		<dd> <blockquote style="font-family:Georgia, 'Times New Roman', Times, serif; text-indent:10px;"> <?php _P($KeyValue['askme_question']); ?> </blockquote> </dd>
	</dl>
	
		<a href='./askme-edit.php?id=<?php _P($KeyValue['askme_id']); ?>'> Answer this Question </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');
?>
Return current item: Prsaar Social Networking Platform