[Eikinskjaldi]

Originally Posted by SDB

a) If i have a threadid, what is the most efficient way to find out if a specific userid has posted in that thread?

b) if i have a query which returns a list of threadids, what is the most efficient join or similar to use in order to establish on a line by line basis whether the same specific userid has posted in that thread?

Thanks in advance.

Simon

a) $foo = $db->query_first("select postid from post where userid=blah1 and threadid=blah2")
if ($foo) {user/thread found}

b) $q = $db->query_read("select distinct threadid from post where userid=blah1 and threadid in (list of theads)")

while ($res=$db->fetch_array($q)) {
$res[threadid]....