" . mysql_error());
mysql_select_db($bdname) or die("Cannot select the bdname.
" . mysql_error());
$query = "SELECT name FROM gruz WHERE date >'$date' - INTERVAL 1 HOUR AND date < '$date' AND Taun1 = '$taun' AND Taun2 = '$taun'";
$nme = mysql_query($query);
if(!$nme)
{
echo mysql_error();
echo "Ошибка выполнения запроса";
exit();
}
// Если запрос вернул результат - производим дальнейшую обработку
if(mysql_num_rows($nme) > 0)
{
}
//
else
{
exit;
}
?>
include("var.php");
ob_start();
$email = "info@dalinoboyschik.com";
$adminemail = "sending@dalinoboyschik.com";
echo "
НОВЫЕ ГРУЗЫ
";
if (!mysql_connect ($SERVER, $USER, $PASSWORD))
{
echo $HEAD;
echo $CP;
echo $BODY;
echo "$ERROR
";
exit;
}
mysql_select_db ($DB);
$date = date("y/m/d G:i:s");
$taun = "UA";
$query = "SELECT COUNT(*) FROM gruz WHERE date >'$date' - INTERVAL 1 HOUR AND date < '$date' AND Taun1 = '$taun' AND Taun2 = '$taun'";
$result = mysql_query($query);
$count = mysql_result($result,0,'COUNT(*)');
$query = "SELECT * FROM gruz WHERE date > '$date'- INTERVAL 1 HOUR AND date < '$date' AND Taun1 = '$taun' AND Taun2 = '$taun' order by date DESC ";
$result = mysql_query($query);
for ($i=0; $i < $count; $i++)
{
echo "";
$f=mysql_fetch_array($result);
echo "$f[date] $f[Taun1] $f[pro] $f[Taun2] $f[city] $f[pro] $f[kuda] $f[chiclo]$f[t]$f[mesyaz] $f[pro] $f[chiclo1]$f[t]$f[mesyaz1] $f[gruz]$f[zp] $f[tonah]$f[tt] $f[obyem]$f[ob]$f[zp] $f[comment] $f[tip] $f[oplata] $f[firma] $f[telephone1]$f[zp] $f[telephone2] $f[telephonmob] $f[name] $f[email]";
echo " |
";
}
$message = ob_get_contents();
ob_end_clean();
$headers=null;
$headers.="Content-Type: text/html; charset=windows-1251\r\n";
$headers.="From:sending@dalinoboyschik.com <".$adminemail.">\r\n";
$headers.="X-Mailer: PHP/".phpversion()."\r\n";
$host=$_SERVER["HTTP_HOST"]; $self=$_SERVER["PHP_SELF"];
$boardurl="http://$host$self";
$boardurl=str_replace("board/tools.php", "board/index.php", $boardurl);
if(!mail($email, "Рассылка1", $message, $headers)) exit("Письмо не может быть отправлено
");
?>