PHP Reporting Database
Prompt error:
Warning:mysql_fetch_array () expects parameter 1 to BES resource, boolean given in C:\yxweb\yjjh\B\dis_ck.php on line 47
Never query the previous report
Source:
Date_default_timezone_set (' Asia/shanghai ');//asia/shanghai
$SJ =date ("y-m-d");//Take the Prophase
Echo $SJ;
$GQ = 0;
$BB = 0;
if (!empty ($_post[' SJ ')) {
$SJ =$_post[' SJ '];
$SJ = "$SJ [6]". " $SJ [7] "." $SJ [8] "." $SJ [9] "." -"." $SJ [0] "." $SJ [1] "." -"." $SJ [3] "." $SJ [4] ";
}
if (!empty ($_post[' GQ ')) {
$gq =$_post[' GQ ';
}
if (!empty ($_post[' BB ')) {
$BB =$_post[' BB ';
}
Echo
$SJ, $gq, ";
$sql =mysql_query ("select * from $BB where gq= ' $gq ' and sj like ' $SJ% ' ORDER by id DESC");
$info =mysql_fetch_array ($sql);
if ($info ==false) {
Echo
$array
";
echo "
Never query the previous report
";
}
ElseIf ($bb = = ' yl ') {
$sqlyl =mysql_query ("select * from yl where gq= ' $gq ' and sj like ' $SJ% ' ORDER BY id DESC limit 1");
Echo $SQLFZB;
$info =mysql_fetch_array ($sqlyl);
?>