а код правильно написан? я его для примера скопировал. хотел что-нибудь сотворить. думаю код скорее всего. если что вот весь:
<html>
<head>
<title>Report</title>
<link href="css/frombase.css" type="text/css" rel="stylesheet">
</head>
<body>
<table border="1" height="" width="" id="table1">
<tr >
<td id="first">НомерСчетчика</td>
<td id="first">ID</td>
<td id="first">Fields</td>
<td id="first">Description</td>
<td id="first">
<select name="time_interval">
<option value="10">10 дней</option>
<option value="15">15 дней</option>
<option value="20">20 дней</option>
<option value="30">30 дней</option>
</select>
<?php
$intervals = array(10,15,20,30);
if( isset($_POST['time_interval']) && in_array(intval($_POST['time_interval']) , $intervals) )
{
$interval = intval($_POST['time_interval']);
$start_date = date('2014.04.18'); // начало интервала
$end_date = date('CURDATE()', strtotime($start_date. '+' . $interval . 'days'));
$query = "SELECT amr_read_history FROM ExecDate WHERE ExecDate >= (CURDATE()-10) AND ExecDate < CURDATE()" .
$start_date . "'ExecDate <= (CURDATE()-10) AND ExecDate < CURDATE()'" . $end_date . "CURDATE()";
}
else
{
echo "Неверный интервал";
}
?>
</td>
<td id="first">Значение</td>
</tr>
<?php
$connect = mysql_connect("192.168.144.6:6299", "report_user", "661610");
$select = mysql_select_db("smartvend", $connect);
$result = mysql_query("SELECT history.MeterNum, fields.ID, history.FieldName, fields.Description, history.ExecDate, history.FieldValue
FROM
amr_fields fields, amr_read_history history
WHERE fields.ID=history.FieldName AND ExecDate>= '2014.04.18'",
$connect);
while ($data = mysql_fetch_row($result))
{
echo"<tr>";
echo"<td>{$data[0]}</td>";
echo"<td>{$data[1]}</td>";
echo"<td>{$data[2]}</td>";
echo"<td>{$data[3]}</td>";
echo"<td>{$data[4]}</td>";
echo"<td>{$data[5]}</td>";
echo"</tr>";
}
function showdate($f)
{
$connect = mysql_connect("******", "report_user", "*********");
$select = mysql_select_db("smartvend", $connect);
$result = mysql_query("SELECT ExecDate FROM `amr_read_history`
WHERE ExecDate>= (CURDATE()-7) AND ExecDate < CURDATE()", $connect);
while ($data = mysql_fetch_row($result))
{
}
}
?>
</table>
</body>
</html>
