figuring out Insert into Select and form data.

turpentyne

I'm a newbie still trying to get used to syntax and whatnot. Hopefully the pros can give me a sense of how to write some simple code.

I'm trying to put the results from a search of table1 and a separate $_POST(variable) into table2.

I've got this, but don't know how to work in the POST variable.


$variable1 = trim($_POST['item_id']);
$variable2 =trim($_POST['anothervariable']);

$query = “INSERT INTO "table1"(item_id, column2) SELECT (column) FROM "table2" WHERE column_in_table2 ="$variable2"......

//here's where I'm not sure what to tell my code to put $variable1 into item_id

bradgrafelman

You've got a couple of syntax errors in both the PHP code as well as the MySQL query, but to answer your main question..

Add the data you want into the SELECT statement, e.g.:

"SELECT '$variable1', columnName FROM table2..."

EDIT: In other words, you're simply SELECT'ing a static string rather than a column or a MySQL function.

PradeepKr

try this,

$variable1 = trim($_POST['item_id']);
$variable2 =trim($_POST['anothervariable']);

$link = mysql_connect('mysql_host', 'mysql_user', 'mysql_password') OR die(mysql_error());
$variable1 = mysql_real_escape_string($variable1);  //filter the hack attempts
$variable2 = mysql_real_escape_string($variable2);  //filter the hack attempts 
//read more about mysql_real_escape_string on http://php.net/manual/en/function.mysql-real-escape-string.php

if( isset($variable1) && isset($variable2) )
{
  $query = "INSERT INTO table1(item_id, column2) 
                        VALUES('$variable1', 
                               (SELECT columnTable2 FROM Table2 WHERE column_in_table2 ='$variable2'))";
}
else
  echo "Variable not set";