grabbing based on unique row entry for specific column

[aebstract]

Here is my current query:

 

mysql_query("SELECT * FROM news WHERE id = '1'") or DIE(mysql_error());

 

I'm trying to do this exact same thing, except that I have a column called topic_id and I want it to only return 1 result per unique topic_id. I'm trying to find a way to do it, if I find something before someone responds I'll update the post. Thanks

[sader]

"SELECT * FROM news WHERE topic_id = '1' LIMIT 1"

[aebstract]

Ack, firstly I posted the wrong query. (sry)

 

mysql_query("
SELECT *
FROM posts
JOIN forums ON ( forums.forum_id = posts.forum_id )
JOIN users ON ( users.user_id = posts.poster_id )
ORDER BY post_time DESC
LIMIT 4
");

 

I'm not trying to grab just 1 row, I'm trying to grab 4 rows from the database, but they have to have a unique topic_id.

[aebstract]

no ideas?

[fenway]

I see no reference to "topic_id" anywhere.