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
Post a Comment