<?php
$clients=array();
$db->query("SELECT * FROM имя_таблицы_в_БД");
while($db->fetch()){$clients[$db->data->id]=$db->data->name;}
reset($clients);
while(list($key,$value)=each($clients)){
$db->query("SELECT * FROM имя_таблицы_в_БД WHERE id_structure='переменная_со_значением_id_записи_ в_БД'");
while($db->fetch()){
$date=$db->data->date;
$comment=$db->data->comment;
$name=ereg_replace("\r","",$name);
$name=ereg_replace("\n","<br>",$name);
}
$filter=array();
$air=array();
$db->query("SELECT * FROM имя_БД WHERE id_structure='переменная_со_значением_id_записи_ в_БД'");
while($db->fetch()){
$filter[]=$db->data->filter;
$air[]=$db->data->air;
}
$filter=join('<br><table width="150px" border="0" cellpadding="0" cellspacing="0"><tr style="background: #afafaf; height: 1px;"><td width="150px"></td></tr></table>',$filter);
$air=join('<br><table width="150px" border="0" cellpadding="0" cellspacing="0"><tr style="background: #afafaf; height: 1px;"><td width=150px"></td></tr></table>',$air);
/*Чередование цветов таблицы*/
$result = mysql_query("SELECT 'переменная_со_значением_id_записи_ в_БД' FROM имя_таблицы_в_БД");
$post = mysql_num_rows($result);
$i=$key;
if($i%2==0){ $color="#f0f0f0"; } else { $color="#FFFFFF"; }
/*Конец кода*/
print " <table class=\"client\" valign=\"top\" align=\"center\" width=\"850px\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n";
print " <tr bgcolor=\"$color\" valign=\"top\" width=\"850px\">\n";
print " <td width=\"200px\" align=\"center\">$value</td>\n";
print " <td><table width=\"300px\" class=\"clients\" align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n";
print " <tr width=\"300px\"><td width=\"150px\"align=\"center\"valign=\"top\">$filter</td>\n";
print " <td width=\"150px\"align=\"center\"valign=\"top\">$air</td></tr>\n";
print " </table></td>\n";
print " <td width=\"150px\" align=\"center\">$date</td>\n";
print " <td width=\"200px\" align=\"justify\">$comment</td>\n";
print " </tr>\n";
print " </table>\n";
}
?>