表mydb1、字段:(id、期数、号码1、号码2、号码3),每期开奖号有三个数字(如356)。其中的3是(号码1字段)、5是(号码2字段)、6是(号码3字段)。等到n期后开奖号又出现356时就用这次356的id减去前一次356的id输出差。$array = array();
while($row = mysql_fetch_assoc($result)){
if(in_array($row['content'],$array)){
$a = $row['id'];
foreach($array as $key =>$content){
if($row['content']==$content){
$b = $key;}}}else{
$array[$row['id']] = $row['content'];}}求各位高手详细写一写, 谢谢PHPMySQL
while($row = mysql_fetch_assoc($result)){
if(in_array($row['content'],$array)){
$a = $row['id'];
foreach($array as $key =>$content){
if($row['content']==$content){
$b = $key;}}}else{
$array[$row['id']] = $row['content'];}}求各位高手详细写一写, 谢谢PHPMySQL
FROM mydb1 a, mydb1 b
WHERE a.号码1 = b.号码1
AND a.号码2 = b.号码2
AND a.号码3 = b.号码3
HAVING sub >0
while($row = mysql_fetch_array($R1))
{
echo $row['']