tecdesign Posted October 5, 2006 Share Posted October 5, 2006 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".')"); Quote Link to comment Share on other sites More sharing options...
Hi I Am Timbo Posted October 5, 2006 Share Posted October 5, 2006 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."')"); Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.