variable and mysql

[tecdesign]

In a Mysql statement I want to read the variable as part of the mysql statement in the php coding. Is this possible? E.g

$sql = mysql_query("
INSERT INTO `transactions` ( `transid` , `username` , `trans_type` , `trans_name` , `trans_method` , `ref` , `code` , `amount` , `date` )
VALUES (
NULL , 'asdf', '."$new_string".')");

[Hi I Am Timbo]

it is possible but you have to have the same number of fields in into and value.  And, your "'s and concatenation are messed up.  it should look like this:

INSERT INTO `transactions` ( `transid` , `username` , `trans_type` , `trans_name` , `trans_method` , `ref` , `code` , `amount` , `date` )
VALUES (
NULL , 'asdf', '".$new_string."')");