function view_post() { global $DB; $View = new BoardView(); $DB->query("SELECT\n tp.id,\n extract(epoch from tp.date_posted) as date_posted,\n m.id as member_id,\n m.name,\n tp.body,\n tp.member_ip,\n t.subject,\n t.id as thread_id,\n m.is_admin\n FROM\n thread_post tp\n LEFT JOIN\n member m\n ON\n m.id=tp.member_id\n LEFT JOIN\n thread t\n ON\n t.id = tp.thread_id\n WHERE\n m.id IN (3122,6100,3122,6050,8879)\n ORDER BY\n random()\n LIMIT 1"); $data = $View->prep_data($DB->load_array()); print "[quote]{$data['3']} posted this on {$data['date']}\n"; print strip_tags($data[4]); print "[/quote]"; exit; }