[hambil]

Originally Posted by thesatman

Thanks for your help the above outputs-

WHERE attachment.extension IN(jar,mid,mmf,mp3,mp4,wav,zip,3gp)

but i need it to output-

WHERE attachment.extension IN ('jar', 'mid' ,'mmf' ,'mp3' ,'mp4' ,'wav' ,'zip' ,'3gp')

chris

PHP Code:

$instr = "'" . str_replace(",", "','", $vbulletin->options['creditsys_filetypes']) . "'";
$sqlwhere = "WHERE attachment.extension IN(" . $instr . ")";