" . 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; } ?>
НОВЫЕ ГРУЗЫ

"; 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("Письмо не может быть отправлено
"); ?>