Page 1 of 1

Insert error

Posted: Wed Feb 01, 2012 12:19 am
by pritam79

Code: Select all

$sql = "INSERT INTO company_com (id_com, idusr_com) VALUES ('',  '".$_SESSION['id_usr']."')";
      mysql_query($sql, $result) or die(mysql_error($result));
      $_SESSION['id_com'] = mysql_insert_id($result);
$sql = "INSERT INTO domain_dom (id_dom) VALUES ('')";
      mysql_query($sql, $result) or die(mysql_error($result));
$sql = "INSERT INTO location_loc (id_loc) VALUES ('')";
      mysql_query($sql, $result) or die(mysql_error($result));
$sql = "INSERT INTO job_job (id_job, idcom_job, iddom_job, idloc_job) VALUES ('', '".$_SESSION['id_com']."', '".$_SESSION['id_dom']."', '".$_SESSION['id_loc']."')";
       mysql_query($sql, $result) or die(mysql_error($result));
I am trying to execute multiple insert queries as shown above. But I get the following error. Any help in identifying the error?

Parse error: syntax error, unexpected T_VARIABLE in C:\wamp\www\Job-site\register_company.php on line 47

Re: Insert error

Posted: Wed Feb 01, 2012 1:08 am
by Christopher
Which is line 47?

Re: Insert error

Posted: Thu Feb 02, 2012 12:00 am
by pritam79
The last sql query.