session_start();
include_once('conn.php');
include_once('check.class.php');
$ssc = new check();
if(isset($_POST['subWin']))
{
$sqlFront = "INSERT INTO `front_two` (`id`, `win_num`, `keys1`, `keys2`, `keys3`, `keys4`, `miss1`, `miss2`, `miss3`, `miss4`) VALUES (NULL, '$_POST[front]', '', '', '', '', '', '', '', '');";
$insertFront = mysql_query($sqlFront) or die(mysql_error());
$SESSION[frontId] = mysql_insert_id(); $sqlLast = "INSERT INTO `last_two` (`id`, `win_num`, `keys1`, `keys2`, `keys3`, `keys4`, `miss1`, `miss2`, `miss3`, `miss4`) VALUES (NULL, '$_POST[last]', '', '', '', '', '', '', '', '');";
$insertLast = mysql_query($sqlLast) or die(mysql_error()) ;
$SESSION[lastId] = mysql_insert_id();
$insert = $insertFront && $insertLast;
if($insert)
{
header("Location: index.php?op=succeed");
}else{
header("Location: index.php?op=feiled");
} } $queryFront = mysql_query('SELECT * FROM `front_two` ORDER BY `id` DESC LIMIT 0,5');
while($rowFront = mysql_fetch_array($queryFront))
{
$frontFive .= $rowFront[win_num].' ';
} $queryLast = mysql_query('SELECT * FROM `last_two` ORDER BY `id` DESC LIMIT 0,5');
while($rowLast = mysql_fetch_array($queryLast))
{
$frontLast .= $rowLast[win_num].' ';
} $frontMsxNums = $ssc->getMaxKey('front_two','sev_fifty','keys',$SESSION[frontId]);//这段不能正常执行,下面四个都可以
$frontMsxNums1 = $ssc->getMaxKey('front_two','rand_nums1','keys1',$SESSION[frontId]);
$frontMsxNums2 = $ssc->getMaxKey('front_two','rand_nums2','keys2',$SESSION[frontId]);
$frontMsxNums3 = $ssc->getMaxKey('front_two','rand_nums3','keys3',$SESSION[frontId]);
$frontMsxNums4 = $ssc->getMaxKey('front_two','rand_nums4','keys4',$SESSION[frontId]);
错误提示是:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'keys = '5340' WHERE `id` = '' LIMIT 1' at line 1为什么id变成空的了getMaxKey()成员函数如下,表单就不给出来了function getMaxKey($winTable,$fifTable,$field,$id) {
$f_arr = array(); //五十组数据的多维数组
$f_sql = "SELECT * FROM $fifTable";
$f_q = @mysql_query($f_sql) ;
while($f_row = mysql_fetch_array($f_q))
{
$str = $f_row['fifty'];
$mode = '/([\s])+/';
$arr = preg_split($mode,$str);
$f_arr[] = $arr;
} $t_sql = "SELECT * FROM $winTable ORDER BY `id` DESC LIMIT 0,50";
$t_q = mysql_query($t_sql) or die(mysql_error()); $t_arr = array();//开奖号码数组 最后五十个
$q_num = 0;
$q_arr = array();
while($t_row = mysql_fetch_array($t_q))
{
$t_arr[] = $t_row['win_num'];
} foreach($f_arr as $fk=>$fv)
{
foreach($t_arr as $tk=>$tv)
{
if(in_array($tv,$fv))
{
$q_arr[] = $q_num;
$q_num = 0;
break;
}else{
$q_num ++;
}
}
}
echo $id.'********<br>';
$m_key_arr = array_keys($q_arr,max($q_arr));
$m_key = $m_key_arr[0]; //第一个最高期的键值 //将最高期插入表中
$sql = "UPDATE $winTable SET $field = '$m_key' WHERE `id` = '$id' LIMIT 1;";
@mysql_query($sql) ; foreach($f_arr[$m_key] as $val)
{
$maxNums .= $val.' '; //最高期的五十组数
} return array(max($q_arr),$maxNums);
}
谢咯