Insert error

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
pritam79
Forum Commoner
Posts: 65
Joined: Wed Mar 26, 2008 9:28 am

Insert error

Post 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
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

Re: Insert error

Post by Christopher »

Which is line 47?
(#10850)
pritam79
Forum Commoner
Posts: 65
Joined: Wed Mar 26, 2008 9:28 am

Re: Insert error

Post by pritam79 »

The last sql query.
Post Reply