select where max id AND ...

[Martin Thomsen]

Hi

I am trying to create a select that selects one row based on two different requirements.

so I want to select the contents of "message"..

Here's my first idea:
SELECT message
FROM `jos_agora_posts`

WHERE
(select max(id) from jos_agora_posts) AND topic_id=2

I just get an empty result..

it should do the where based on topic_id=2 and then select the row where id has the highest integer.

Any advice :-)