Okay,
form:
echo '<form method="post" action="">
Titel:<br/> <input class="nyhedsfelt" type="text" name="topic_subject" /><br />
Kategori:<br />';
echo '<select class="nyhedsselect" name="topic_cat">';
while($row = mysql_fetch_assoc($result))
{
echo '<option class="optionnyheder" value="' . $row['cat_id'] . '">' . $row['cat_name'] . '</option>';
}
echo '</select><br />';
echo 'Indhold: <br /><textarea class="nyheder" name="post_content" width="500px"/></textarea><br /><br />
<input type="submit" value="Opret nyhed" />
</form>';
}
Her sætter jeg det ind:
$sql = "INSERT INTO
nyheder_posts(post_content,
post_date,
post_topic,
post_by)
VALUES
('" . mysql_real_escape_string($_POST['post_content']) . "',
NOW(),
" . $topicid . ",
" . $_SESSION['user_id'] . "
)";
Her udtrækker jeg det:
//udtrækker værdierne fra databasen
$posts_sql = "SELECT
nyheder_posts.post_topic,
nyheder_posts.post_content,
nyheder_posts.post_date,
nyheder_posts.post_by,
users.user_id,
users.user_name
FROM
nyheder_posts
LEFT JOIN
users
ON
nyheder_posts.post_by = users.user_id
WHERE
nyheder_posts.post_topic = " . mysql_real_escape_string($_GET['id']) . "
LIMIT
$start, $per_page";
og viser det:
while($posts_row = mysql_fetch_assoc($posts_result))
{
echo 'Af <a class="links" href="
http://www.sxxx.dk/user_profiles.php?user_id= ' . $posts_row['user_id'] . '"> ' . $posts_row['user_name'] . '</a> den <i>' . date('d-m-Y H:i', strtotime($posts_row['post_date'])) . '</i><br/>
<br /><p class="tekst">
' . htmlentities(stripslashes($posts_row['post_content'])) . '
</p><hr width="500px" size="0.5px" align="center" noshade color="silver"/>
';
}