php - Get values from one table and put in another table -


i need take values 1 table , save them anther table. values users(id, first_name, last_name) , cars(id, makers, model) third table. i've tried something, error: have error in sql syntax; check manual corresponds mysql server version right syntax use near '' @ line 1

this code:

<?php include "db_connection.php"; session_start();  $res=mysql_query("select * users id_user=".$_session['user']); $userrow=mysql_fetch_array($res);  if(isset($_post["btn"])) {     $maker=$_post["maker"];     $model=$_post["model"];     $year=$_post["year"];     $fuel=$_post["fuel"];     $power=$_post["power"];       $sql2="insert models values (0,'$maker','$model','$year','$fuel','$power')";     $query2=mysql_query($sql2);       $query = ("select id_user, f_name, l_name users id_user=".$_session['user']);      $result = mysql_query($query);      if(!$result) { die($query."<br />".mysql_error()); }       while($row = mysql_fetch_assoc($result))      {           $data[]=$row;      }        if (!mysql_select_db("car")) { die(mysql_error()); }        foreach($data $row)       {           $query  = "insert evidencija (id_k,ime,prezime,'$maker','$model') values ('";           $query .= mysql_real_escape_string($row['id_user'])."','";           $query .= mysql_real_escape_string($row['f_name'])."','";           $query .= mysql_real_escape_string($row['l_name'])."'";            if(!mysql_query($query)) { die($query."<br />".mysql_error()); }        }  } include "header.php"; ?> 

please change $query to:

    $query  = "insert evidencija (id_k,ime,prezime,maker,model) values ('";       $query .= mysql_real_escape_string($row['id_user'])."','";       $query .= mysql_real_escape_string($row['f_name'])."','";       $query .= mysql_real_escape_string($row['l_name'])."','";       $query .= mysql_real_escape_string($maker)."','";       $query .= mysql_real_escape_string($model)."')";  

Comments