Find and match id in database

[ShaneV]

Hi,

 

I use a thanks mod on my board and i want to make a page where u can find a history of topics where a users had used thanks button.

 

there is a row 'thanks_post' in ibf_posts where all user id's can be found that used the button like this: 16,58,56,48,584

 

This is not working with sql query appears

if (in_array($randomValue, $sqlResult))

 

Found this on another board but don't know how to use it in a IPB based query.

 

SELECT *, id IN (SELECT id FROM table WHERE {blabla}) FROM table

 

Or

 

SELECT *, id IN (1,5,20,64) FROM table

 

Can somebody help?

Thanks

 

Greetz

[Michael]

Hi,

 

I use a thanks mod on my board and i want to make a page where u can find a history of topics where a users had used thanks button.

 

there is a row 'thanks_post' in ibf_posts where all user id's can be found that used the button like this: 16,58,56,48,584

 

This is not working with sql query appears

if (in_array($randomValue, $sqlResult))

 

Found this on another board but don't know how to use it in a IPB based query.

 

SELECT *, id IN (SELECT id FROM table WHERE {blabla}) FROM table

 

Or

 

SELECT *, id IN (1,5,20,64) FROM table

 

Can somebody help?

Thanks

 

Greetz

 

Try something like this.

 

$this->ipsclass->DB->simple_construct( array( 'select' => '*', 'from' => 'topics', 'where' => "thanks_post IN(1,5,20,64)" ) );
$this->ipsclass->DB->simple_exec();