Chatting room php & mysql (4)

Chat room php & amp; mysql (4) fourth page name = "index. php"

Include "../signup/mysql. php ";
Header ("Expires: Sun, 28 Dec 1997 09:32:45 GMT ");
Header ("Cache-Control: no-cache, must-revalidate ");
Header ("Pragma: no-cache ");
Header ("Content-Type: text/html; charset =$ {Charset }");

?>



Charmain







$ Max_row_length = 30;

$ Select = "select row from user_message order by row DESC ";
$ Result = mysql_query ($ select) or die ("false FGG ");
$ Rowlist = mysql_fetch_array ($ result) or die ("false ");
$ Max_row = $ rowlist ["row"];


If ($ max_row> $ max_row_length ){


$ Delete_row = $ max_row-$ max_row_length + 1;

// Echo $ max_row ."
". $ Delete_row;
$ Select = "select row from user_message where row <". $ delete_row;
$ Result = mysql_query ($ select) or die ("false ");
While ($ row = mysql_fetch_array ($ result ))
{
$ SQL = "delete from user_message where row <". $ delete_row;

Mysql_query ($ SQL) or die ("del false1 ");
}


$ Left = $ delete_row;
}

Else {$ left = 1;

}

For ($ I = $ max_row; $ I >=$ left; $ I --)
{
$ SQL = "SELECT message, userid, object, status, color, action1, time1 FROM user_message where row = '$ I '";
$ Result = mysql_query ($ SQL) or die (mysql_error ());
$ Row = mysql_fetch_array ($ result );
$ Time1 = $ row ["time1"];

$ Usert1 = $ row ["userid"];
$ Objectt1 = $ row ["object"];
$ SQL = "select id from chat_user_list where userid = '$ usert1 '";
$ Result = mysql_query ($ SQL) or die (mysql_error ());
$ Rowt1 = mysql_fetch_array ($ result );
$ Usert5 = $ rowt1 ["id"];

$ SQL = "select id from chat_user_list where userid = '$ object1 '";
$ Result = mysql_query ($ SQL) or die (mysql_error ());
If ($ rowt2 = mysql_fetch_array ($ result ))
$ Bojectt5 = $ rowt2 ["id"];
Else $ bojectt5 = "everyone ";



If ($ row ["userid"]! = $ Userid ){

$ User1 = "". $ usert5 ."";
}
Else $ user1 = $ usert5;
If ($ row ["object"]! = $ Userid ){

$ User2 = "". $ bojectt5 ."";}
Else $ user2 = $ bojectt5;
$ Message2 = $ row ["message"];
$ Message3 = htmlspecialchars ($ message2 );

$ Message1 =" ". $ User1 ."For ". $ user2 ." ". $ Row [" action1 "].":". $ Message3 ."";

If ($ row ["status"] = 1 ){
If ($ row ["object"] = $ userid | $ row ["userid"] = $ userid)
Echo "private chat". $ time1. "". $ message1 ."
";
Else continue;
}
Else {
Echo $ time1. ". $ message1 ."
";

}
}

?>