Code structure ?

Question

I try to make some modification for example when asking a question to add a new selectable field .... and I arrived to this strange query


        qa_db_query_sub($db,
            'INSERT INTO ^posts (type, parentid, userid, cookieid, title, content, tags, notify, created) VALUES ($, #, $, #, $, $, $, $, NOW())',
            $type, $parentid, $userid, $cookieid, $title, $content, $tagstring, $notify
        );


what $ and # mean...  

and where I need to add that field... in this query..  let say


        qa_db_query_sub($db,
            'INSERT INTO ^posts (type, parentid, userid, cookieid, title, content, MYFIELD, tags, notify, created) VALUES ($, #, $, #, $, $,  $, $, $, NOW())',
            $type, $parentid, $userid, $cookieid, $title, $content, $MYFIELD, $tagstring, $notify
        );

AND PAGE  qa_page_ask ?

Answer 1

The $ and # symbols are substituted with the parameters that follow, in the same order. Use a $ for a definite string value (so that the parameter is put in quotes, even if it's numerical), and a # for other values (quotes only used if the parameter is a string).

So looking at your example, it looks like you've done fine.