求助！！php网页编辑sql db，数据出不来，要前五个工作日

来源：百度知道编辑：UC知道时间：2024/06/03 18:32:16

<?php
/* date & time*/
echo $todaydate = date("F j, Y (T, g:i a) ");

include("config.php");

function subpast7days($day)
{
include("config.php");

$today = date("m/d/Y");
$now=time();
$m=$day*24*60*60;
$diff=$now-$m;
$past7days=date("<br>m/d/Y",$diff);

$range_TAT = array("<=5",">5","");
$flag = array("Closed Within Target (TAT = 5)","Closed Exceed Target (TAT = 5)","Past 5 daysAll Closed RMA");
$description = array("3500","1200","6400","1430");

/*get the number*/
$count = count($range_TAT);
for ($j = 0;$j<$count;$j++)
{
/*put all query into array */
$query2[$j]="select salesorg, SUM(qty) orderqty from (SELECT salesorg, salesorderno, COUNT(DISTINCT salesorderno) qty FROM

1. 看看40行有语法错误
2.把sql打出来放phpmyadmin运行看看运行结果。
3.你的表结构都什么样？

$query2[$j]="select salesorg, SUM(qty) orderqty from (SELECT salesorg, salesorderno, COUNT(DISTINCT salesorderno) qty FROM zv09_dailyrawfmt WHERE TAT $range_TAT[$j] and left(billingdate,10) <= "left($today,10)" and left(billingdate,10) >= "left($past7days,10)" and GROUP BY Salesorg, salesorderno) sum_table where 1 ";

字符串连接用 .

如果是用 mysql 方法的话..那么"重复了..用'

PHP网页编辑高手请进网页编辑问题求助！！ php网页可以用Dreamwerver编辑吗？ (高手求助)注册PHP网页出现sex php网页是用什么软件编辑的？有可视化的编辑软件吗？紧急求助!!!!!怎么弄网页编辑? editplus编辑PHP php求助！ php连接sql数据库 php与sql问题