Jump to content

Archived

This topic is now archived and is closed to further replies.

tecdesign

variable and mysql

Recommended Posts

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".')");

Share this post


Link to post
Share on other sites
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."')");

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.