SQL fargekoding

[inaktiv000]

Kom innom BBCode hjelpen, og så at det fantes SQL highlighting! Må bare prøve..

 

<?
$sql = '
SELECT forum_topics.topic_title AS title,
forum_topics.topic_replies AS replies,
forum_posts_text.post_text AS text,
forum_posts.post_time AS timestamp,
forum_users.username AS username,
forum_users.user_email AS email,
forum_users.user_avatar AS avatar,
forum_users.user_avatar_type AS avatartype,
forum_ranks.rank_title AS rank,
forum_posts.post_id AS postid
FROM forum_topics INNER JOIN forum_posts ON forum_topics.topic_first_post_id = forum_posts.post_id
INNER JOIN forum_posts_text ON forum_posts.post_id = forum_posts_text.post_id
INNER JOIN forum_users ON forum_posts.poster_id = forum_users.user_id
LEFT JOIN forum_ranks ON forum_users.user_rank = forum_ranks.rank_id
WHERE forum_topics.forum_id = 1
ORDER BY timestamp desc LIMIT 5
';
?>

[PT]

<-- klikk

[inaktiv000]

Ah er ikke helt inni off topic forumet ennå Men det var kanskje en opplysning som flere har bruk for?

[TLZ]

utrolig praktisk da...