Различные вопросы по PHP и MySQL

REPLACE INTO a_forum_journal
(user_id,topic_id,count,new,type,read,time)
VALUES (1,3,0,0,0,0,1355309283)

Folour (12.12.2012 / 13:50)
В чем ошибка?

REPLACE INTO a_forum_journal
(user_id,topic_id,count,new,type,read,time)
VALUES (1,3,0,0,0,0,1355309283)

Выдает
You have an error in your SQL syntax; check the manual t

public function action_add() {
$this->only_users();
$this->topic_exists();
$result = $this->db->query("REPLACE INTO #__forum_journal
(user_id,topic_id,count,new,type,read,time)
VALUES (".USER_ID.",$this->id,0,0,0,0,".time...")");

$url = a_url('forum/viewtopic', 'topic_id=' . $this->id);
if($result)a_notice('Вы успешно подписались на тему', $url);
elsea_error('Произошла ошибка', $url);
}

Folour (12.12.2012 / 14:19)
2 В одном.
[php]
public function action_add() {
$this->only_users();
$this->topic_exists();
$result = $this->db->query("REPLACE INTO #__forum_journal (user_id,topic_id,count,new,type,read,time)

$sql = "SELECT SQL_CALC_FOUND_ROWS fj.count, fj.type, fj.topic_id AS tid, t.name, fj.new ";
$sql .= "FROM #__forum_journal AS fj LEFT JOIN #__forum_topics AS t ";
$sql .= "ON fj.user_id = '".USER_ID."' AND fj.topic_id = t.topic_id AND fj.type != '1' AND fj.new != '0' ";
$sql .= "ORDER BY fj.time ASC LIMIT $this->start, $this->per_page";