У Вас есть один вопрос? - Тогда задайте его тут (v.6)

Dagestan_ец (11.12.2011/11:05)
третья не пашет

$req = mysql_query("SELECT `my_guests`.*, `users`.`colornick`, `users`.`name`, `users`.`sex`, `users`.`datereg`, `users`.`lastdate` FROM `my_guests` LEFT JOIN `users` ON `my_guests`.`guest_id` = `users`.`id`  WHERE `my_guests`.`my_id` = '" . $user_id . "' ORDER BY `my_guests`.`time` DESC LIMIT " . $start . ", " . $kmess . ";");
 while ($res = mysql_fetch_assoc($req)) {
  echo $i % 2 ? '<div class="list1">' : '<div class="list2">';
  echo '<b><a href="' . $home . '/str/anketa.php?id=' . $res['guest_id'] . '"><span style="color:#' . $res['colornick'] . '">' . $res['name'] . '</span></a></b>&nbsp;';

$req = mysql_query("SELECT `id`,`text`, `from`  FROM `forum` where type='t' ORDER BY time DESC LIMIT 6; ");
while ($arr = mysql_fetch_array($req)){
$nikuser = mysql_query("SELECT `from`,`time`,`text` FROM `forum` WHERE `type` = 'm' AND `close` != '1' AND `refid` = '" . $arr['id'] . "'ORDER BY time DESC LIMIT 1;");
$nam = mysql_fetch_array($nikuser);
$nam['text'] = tags($nam['text']);
$tvoi = mysql_fetch_assoc(mysql_query("select `colornick` from `users` where `id`='".$user['id']."';"));//выборка цвета ника из базы
echo'<div class="dagmenu4">';
echo '<img src="' . $home . '/imgg/OBSH.PNG"/><a href="forum/index.php?id='.$arr['id'].'"> <b>'.$arr[text].'</b></a><br />'. mb_substr(smileys($nam['text']), 0, 200) .'<br /><b><font color="#' . $nam['colornick'] . '">'.$nam['from'].'</font></b>';

$vrp = $nam['time'] + $set_user['sdvig'] * 3600;
echo ' <font color="#777777"><small>(' . date("d.m в H:i", $vrp) . ")</small></font>";
echo'<hr/></div>';
}

Dagestan_ец (11.12.2011/11:29)
~XeOn~, спасибо большое а тут

$req = mysql_query("SELECT `id`,`text`, `from`  FROM `forum` where type='t' ORDER BY time DESC LIMIT 6; ");
while ($arr = mysql_fetch_array($req))
{
	$nikuser = mysql_query("SELECT `from`,`time`,`text` FROM `forum` WHERE `type` = 'm' AND `close` != '1' AND `refid` = '" . $arr['id'] . "'ORDER BY time DESC LIMIT 1;");
	$nam = mysql_fetch_array($nikuser);
	$nam['text'] = tags($nam['text']);
	$color = mysql_fetch_assoc(mysql_query("select `colornick` from `users` where `name`='".$nam['from']."';"));//выборка цвета ника из базы
	echo'<div class="dagmenu4">';
	echo '<img src="' . $home . '/imgg/OBSH.PNG"/><a href="forum/index.php?id='.$arr['id'].'"> <b>'.$arr[text].'</b></a><br />'. mb_substr(smileys($nam['text']), 0, 200) .'<br /><b><span color="#' . $color['colornick'] . '">'.$nam['from'].'</span></b>';

	$vrp = $nam['time'] + $set_user['sdvig'] * 3600;
	echo ' <font color="#777777"><small>(' . date("d.m в H:i", $vrp) . ")</small></font>";
	echo'<hr/></div>';
}