View file rek/list-active.php

<?php
require_once ('../includes/start.php');
require_once ('../includes/functions.php');
require_once ('../includes/header.php');
include_once ('../themes/header.php');
require_once 'connect.php'; //ConnectDB
include_once'head.php'; //header

echo' <div class="success"> Активные ссылки</div>';

echo'<a href="list-init.php">не оплаченные</a><br/>';

$rmq=mysql_query('SELECT `url`,`name`,`color`,`bold`,`italic`,`expire` FROM `worldkassa` WHERE `expire`>NOW() ORDER BY `payment` ASC')or die('DB: '.mysql_error());

$imr=mysql_num_rows($rmq);

if($imr>0){

echo'Всего: '.$imr.'<br/>';

while($link=mysql_fetch_assoc($rmq)){

echo'<a '.(($link['color'] || $link['bold'] || $link['italic']) ? 'style="'.($link['bold']?'font-weight:bold;':'').($link['italic']?'font-style:italic;':'').($link['color']?'color:'.$link['color']:'').'" ' : '' ).'href="'.$link['url'].'" target="_blank">'.$link['name'].'</a> <span style="font-size:x-small">'.$link['url'].'</span>
<br/>
До '.$link['expire'].'
<br/>';

};

}else{
echo'<div class="error">Нету ссылок/div>';
};


include_once'foot.php';
include_once ('../themes/footer.php');
?>