$link = mysql_connect("localhost", "dracula", "[eqghjqltn") or die("DEADLINK");
mysql_select_db('work', $link);
mysql_query($query, $link);
$cou=0;
$d=date("d");
$m=date("m");
$Y=date("Y");
echo "
# |
дата |
счет |
организация |
записи менеджера|примечание |
исполнитель|в архив |
действия офиса|примечание |
ред. |
";
$query = "select
today,
cow,
block,
color,
count,
manager,
firma,
manager_r,
manager_r_prim,
peon,
ofice,
ofice_prim,
plan,
dolg,
plateg,
plateg_data,
material_price,
rabota_price
FROM admin where block='on' order by today asc;";
$result = mysql_query($query, $link);
while ($row = mysql_fetch_array($result)){
$cou++;
// $bg='ccffcc';
//echo "";
echo "
";
echo "".$cou." | ";
$year = substr($row['today'], 4, 4);
$month = substr($row['today'], 2, 2);
//if ($month == '09') {
// $month ='ноя';
// }
$day = substr($row['today'], 0, 2);
$data = "$day.$month.$year";
echo "".$data." | ";
echo "".$row['count']." | ";
echo "".$row['firma']." | ";
echo "
".$row['manager_r']."
| ";
echo "
".$row['peon']."
| ";
echo "
".$row['ofice']."
| ";
echo "
 | ";
//echo "
//  | ";
echo "
|
";
}
echo "
организация |
записи менеджера |
примечание |
исполнитель |
действия офиса |
примечание |
сохранить |
";
?>