Вот код (+/-)
$q = mysql_query("SELECT * FROM `f_post` WHERE `id_user` = '".$user['id']."' AND `chit` = '0' ORDER BY `time` ASC LIMIT $start, ". $p_page);
while ($post = mysql_fetch_assoc($q)) {
echo '<div id="post_sys">';
$ank = mysql_fetch_assoc(mysql_query("SELECT * FROM `users` WHERE `id` = '". $post['id_user'] ."' LIMIT 1"));
$reply = mysql_fetch_array(mysql_query("SELECT `login` FROM `users` WHERE `id` = '". $post['reply'] ."' LIMIT 1"));
if ($post['hide'] == NULL) {
echo '<span id="c_date">'. ptime($post['time']) .'</span>';
echo '<table><tr><td>';
if (string($post['msg']) <= 300) $post['msg'] = $post['msg'];
else $post['msg'] = cut(string($post['msg'], 300)) .''.cut($post['msg'], 299).' <b>...</b> <span id="right"><a href="topic.php?id='. $them['id'] .'&menu=action&post='. $post['id'] .'">Читать все</a></span>';
echo output(antispam($post['msg']));
echo '</td></tr>
</table>';
} else {
$colornick = mysql_fetch_assoc(mysql_query("select `colornick`,`colornick2` from `users` where `id`='".$ank['id']."'"));
echo '<span id="c_date">'. ptime($post['time']) .'</span>
<table>
<tr>
<td>';
avatar($ank['id']);
echo ' </td><td>';
echo online($ank['id']);
echo ''.gradient(''. $ank['login'] .'', '' . $colornick['colornick'] . '',''.$colornick['colornick2'].'').'<br />';
if ($user['position'] == 'admin' || $user['position'] == 'moder' || $user['position'] == 'mod_f') {
echo '<br /><span id="font">Комментарий скрыл
<span id="red">'. $post['hide'] .'</span>
</span>
</td>
</tr>
</table>
<hr>';
if (string($post['msg']) <= 300) $post['msg'] = $post['msg'];
else $post['msg'] = cut(string($post['msg'], 300)) .''.cut($post['msg'], 299).' <b>...</b> <span id="right"><a href="?id='. $them2['id'] .'&menu=action&post='. $post['id'] .'">Читать все</a></span>';
echo output(antispam($post['msg']));
} else {
echo '<br /><span id="red">Комментарий скрыт</span>
</td>
</tr>
</table>';
}
}
echo '</div>';
}Проблема в том что. ссылка не работает. То есть '. $them2['id'] .' не определяется
<a href="?id='. $them2['id'] .'&menu=action&post='. $post['id'] .'">Читать все</a>Есть параметр с которым она определяется
$q = mysql_query("SELECT * FROM `f_post` WHERE `forum_id` = '". $forum['id'] ."' AND `cat_id` = '". $cat['id'] ."' AND `them_id` = '". $them['id'] ."' ORDER BY `time` ASC LIMIT 1");У меня не получается воедино соединить
$q = mysql_query("SELECT * FROM `f_post` WHERE `id_user` = '".$user['id']."' AND `chit` = '0' ORDER BY `time` ASC LIMIT 1");и
$q = mysql_query("SELECT * FROM `f_post` WHERE `forum_id` = '". $forum['id'] ."' AND `cat_id` = '". $cat['id'] ."' AND `them_id` = '". $them['id'] ."' ORDER BY `time` ASC LIMIT 1");