OK so i have this:
PHP Code:
$chocolate = $vbulletin->db->query_read("
SELECT column1
FROM " . TABLE_PREFIX . "test
WHERE columnfudge > '999'
LIMIT 1
");
$vbulletin->db->query_write("
INSERT INTO " . TABLE_PREFIX . "test (column1,columnfudge) VALUES ('[2] $chocolate','0')
");
in a cron. When the cron runs it picks up value of $chocolate (which is abc in this case) It doesn't add it as "[2] abc" and "0" it does "[2] Resource id #18" and "0". Any Ideas?