1
PHP / Помогите! MySQL+PHP вывод определённых полей таблицы!
« : 02 Декабря 2003, 00:26:27 »
Привет!
Народ добрый помогите пожалуйста.
У меня есть скрипт:
function newMessages($min_num = 0){
global $chat_id, $link,
$NORMAL_TYPE, $PRIVATE_TYPE, $ACTION_TYPE, $ANNOUNCE_TYPE;
if(!$link)connect();
$ignore_result = mysql_query("SELECT ignore_id FROM ignores WHERE id=$chat_id");
$ignore_str = "";
for($i=0; $i $id = mysql_result($ignore_result, $i, "ignore_id");
$ignore_str .= " AND ";
$ignore_str .= "id_from<>$id AND id_to<>$id ";
}
$smiley_result = mysql_query("SELECT * FROM smiley");
$result = mysql_query("SELECT uf.id AS fromid, uf.nick AS fromnick,
ut.id AS toid, ut.nick AS tonick,
uf.color,
msg_text, msg_type
FROM users uf, users ut, messages
WHERE num>$min_num AND uf.id=id_from AND ut.id=id_to
AND
(msg_type<>$PRIVATE_TYPE OR msg_type=$PRIVATE_TYPE
AND(id_from=$chat_id OR id_to=$chat_id)) $ignore_str
ORDER BY num DESC
LIMIT 50");
$res = "";
$r=mysql_num_rows($result);
for($i=0; $i<$r; $i++){
$fromid = mysql_result($result, $i, "fromid");
$fromnick = mysql_result($result, $i, "fromnick");
$toid = mysql_result($result, $i, "toid");
$tonick = mysql_result($result, $i, "tonick");
$msg_text = mysql_result($result, $i, "msg_text");
// âñòàâëÿåì ñìàéëû...
for($k=0; $k $code = mysql_result($smiley_result, $k, "code");
$filename = mysql_result($smiley_result, $k, "filename");
$msg_text = str_replace($code, "", $msg_text);
}
$msg_type = mysql_result($result, $i, "msg_type");
$color = mysql_result($result, $i, "color");
if($msg_type == $PRIVATE_TYPE) $res .= "";
if($msg_type == $ACTION_TYPE) $res .= "";
if($fromid != -1 && $msg_type != $ANNOUNCE_TYPE) $res .= "$fromnick ";
if($msg_type != $ANNOUNCE_TYPE && $msg_type != $ACTION_TYPE) $res .= ": ";
if($toid != -1 && $msg_type != $ANNOUNCE_TYPE) $res .= " $tonick: ";
if($msg_type == $ANNOUNCE_TYPE) $res .= "";
else $res .= "";
$res .= "$msg_text
";
if($msg_type == $ANNOUNCE_TYPE) $res .= " \\n";
else $res .= "";
if($msg_type == $ACTION_TYPE) $res .= "\\n";
if($msg_type == $PRIVATE_TYPE) $res .= "\\n";
}
return $res;
}
connect();
if($nn4 || $msie3 || $opera){
echo newMessages();
}
else echo "";
$result = mysql_query("SELECT lastmsg FROM online WHERE id=$chat_id");
$lastmsg = mysql_result($result, 0, 0);
if(!$lastmsg) // ÕáÛØ äàÕÙÜ ×ÐÓàãÖÐÕâáï ßÕàÒëÙ àÐ×...
echo "\\n";
// ÞÑÝÞÒÛïÕÜ timeref, çâÞÑë ÝÐá ÝÕ áÞçÛØ ßÞÔÒØáèØÜØ
mysql_query("UPDATE online SET timeref=".time()." WHERE id=$chat_id");
disconnect();
?>
Народ добрый помогите пожалуйста.
У меня есть скрипт:
function newMessages($min_num = 0){
global $chat_id, $link,
$NORMAL_TYPE, $PRIVATE_TYPE, $ACTION_TYPE, $ANNOUNCE_TYPE;
if(!$link)connect();
$ignore_result = mysql_query("SELECT ignore_id FROM ignores WHERE id=$chat_id");
$ignore_str = "";
for($i=0; $i
$ignore_str .= " AND ";
$ignore_str .= "id_from<>$id AND id_to<>$id ";
}
$smiley_result = mysql_query("SELECT * FROM smiley");
$result = mysql_query("SELECT uf.id AS fromid, uf.nick AS fromnick,
ut.id AS toid, ut.nick AS tonick,
uf.color,
msg_text, msg_type
FROM users uf, users ut, messages
WHERE num>$min_num AND uf.id=id_from AND ut.id=id_to
AND
(msg_type<>$PRIVATE_TYPE OR msg_type=$PRIVATE_TYPE
AND(id_from=$chat_id OR id_to=$chat_id)) $ignore_str
ORDER BY num DESC
LIMIT 50");
$res = "";
$r=mysql_num_rows($result);
for($i=0; $i<$r; $i++){
$fromid = mysql_result($result, $i, "fromid");
$fromnick = mysql_result($result, $i, "fromnick");
$toid = mysql_result($result, $i, "toid");
$tonick = mysql_result($result, $i, "tonick");
$msg_text = mysql_result($result, $i, "msg_text");
// âñòàâëÿåì ñìàéëû...
for($k=0; $k
$filename = mysql_result($smiley_result, $k, "filename");
$msg_text = str_replace($code, "", $msg_text);
}
$msg_type = mysql_result($result, $i, "msg_type");
$color = mysql_result($result, $i, "color");
if($msg_type == $PRIVATE_TYPE) $res .= "";
if($msg_type == $ACTION_TYPE) $res .= "";
if($fromid != -1 && $msg_type != $ANNOUNCE_TYPE) $res .= "$fromnick ";
if($msg_type != $ANNOUNCE_TYPE && $msg_type != $ACTION_TYPE) $res .= ": ";
if($toid != -1 && $msg_type != $ANNOUNCE_TYPE) $res .= " $tonick: ";
if($msg_type == $ANNOUNCE_TYPE) $res .= "
else $res .= "";
$res .= "$msg_text
";
if($msg_type == $ANNOUNCE_TYPE) $res .= "
else $res .= "";
if($msg_type == $ACTION_TYPE) $res .= "\\n";
if($msg_type == $PRIVATE_TYPE) $res .= "\\n";
}
return $res;
}
connect();
if($nn4 || $msie3 || $opera){
echo newMessages();
}
else echo "";
$result = mysql_query("SELECT lastmsg FROM online WHERE id=$chat_id");
$lastmsg = mysql_result($result, 0, 0);
if(!$lastmsg) // ÕáÛØ äàÕÙÜ ×ÐÓàãÖÐÕâáï ßÕàÒëÙ àÐ×...
echo "\\n";
// ÞÑÝÞÒÛïÕÜ timeref, çâÞÑë ÝÐá ÝÕ áÞçÛØ ßÞÔÒØáèØÜØ
mysql_query("UPDATE online SET timeref=".time()." WHERE id=$chat_id");
disconnect();
?>