Help With A Query

[zero477]

Hello,

 

I am not findinf any results in the following query. Can someone explain me what i am doing wrong?

 

$searchpostsofforum= vB::$db->query_read("


SELECT *
FROM " . TABLE_PREFIX . "post
WHERE threadid=
(SELECT threadid
FROM " . TABLE_PREFIX . "forum
WHERE forumid='$id_foro'

)
ORDER BY dateline DESC
LIMIT 10")
or die(mysql_error());
while ($posts = vB::$db->fetch_array($searchpostsofforum))
{


}

print_r($posts);

[Barand]

does it give results if you put the print_r inside the loop?

 

edit

PS You should use a join

Edited November 22, 2012 by Barand

[DavidAM]

Turn on error reporting. That query will fail if there is more than one post in the forum. When using a subquery for an equals ("=") condition, the subquery must not return more than one row. You would have to use "IN" instead of "=" with the subquery approach. But, as Barand said, you should be using a JOIN instead.