array in mysql

[wolfe]

i cant get this array to work

PHP Code:

$array = "59,63,64,69,72";

    $threadarray = $vbulletin->db->query_read("
        SELECT thread.*, icon.title AS icontitle, icon.iconpath
        FROM " . TABLE_PREFIX . "thread AS thread 
        LEFT JOIN " . TABLE_PREFIX . "icon AS icon ON(icon.iconid = thread.iconid)
        WHERE
            thread.visible = 1 AND thread.forumid IN ('" . implode(",", $array) . "')
        ORDER BY dateline DESC 
        LIMIT 15"); 


it returns nothing except this error

Warning: implode() [function.implode]: Invalid arguments passed

[Opserty]

$array is not an array, its just a string. You don't need to implode it.

PHP Code:

// An Array
$array = array ( 59, 63, 64, 72);
echo implode('-', $array); 
// Outputs 59-63-64-72 


But in your example you don't need to implode it because the numbers are already seperated by commas. So just change implode(",", $array) to $array.

[wolfe]

m8 thats not what i needed i need it to only show threads that are in them forumids ?

[Lynne]

I think he told you what you need to do:

Originally Posted by wolfe

m8 thats not what i needed i need it to only show threads that are in them forumids ?

Originally Posted by Opserty

$array is not an array, its just a string. You don't need to implode it.

So just change implode(",", $array) to $array.

[wolfe]

nevermind m8 that worked gr8 thx :P