=200) $message=substr($message1,0,200); else $message="(".$date.$time.")".$message1; $result1 = mysql_query("SELECT * FROM chatmessage") or die(mysql_error()); $num1=mysql_numrows($result1); ++$num1; $result = mysql_query("SELECT * FROM chatusers WHERE userID='$userID'") or die(mysql_error()); $num=mysql_numrows($result); if($num) $result= mysql_query("INSERT INTO chatmessage VALUES ('$num1','$userID','$message')") or die(mysql_error()); if($num1>8){//???? $inm=1; $result1 = mysql_query("DELETE FROM chatmessage WHERE id='$inm'") or die(mysql_error()); for($in=2;$in<10;++$in){//**** $inm=$in-1; $result= mysql_query("UPDATE chatmessage SET id='$inm' WHERE id='$in'") or die(mysql_error()); }//**** }//???? $result1 = mysql_query("SELECT * FROM chatmessage ORDER BY id ASC") or die(mysql_error()); $num_row=mysql_numrows($result1); mysql_close(); echo "
"; for($i=0;$i<$num_row;++$i){//;;;; $userID=mysql_result($result1,$i,"userID"); $message=mysql_result($result1,$i,"message"); echo " $userID: $message
"; }//;;;; ?>