[SOLVED] inserting into two related tables

[ROCKINDANO]

Hello everyone,

 

I am working on a project that requires updating two tables using a form.

the two tables are related tables that need to be updated  when submitting the form. my two tables are:

 

fulltime (department, pay, jobnum, dateclose, job_id)

departments (dept_id, job_id, summary, description, conditions, ex, ed)

 

i have tried updating both tables using two querys but only the fulltime table get updated and nothing gets inserted into the department tables.

 

this is my code:

 

					$department=$_POST["department"];
					$pay=$_POST["pay"];
					$jobnum=$_POST["jobnum"];
					$dateclose=$_POST["dateclose"];
					$job_id=$_POST["job_id"];

					$dept_id=$_POST["dept_id"];
					$summary=$_POST["summary"];
					$description=$_POST["description"];
					$conditions=$_POST["conditions"];
					$ex=$_POST["ex"];
					$ed=$_POST["ed"];

					if(!isset($department) || empty($pay))
					die ("<p>You can't leave the title field blanck.</p>");
					if(!isset($department) || empty($pay))
					die ("<p>You can't leave the story field field blanck.</p>");

				//INSERTS INTO PROPER TABLES.
				$query= "INSERT INTO fulltime VALUES ('{$department}','{$pay}','{$jobnum}','{$dateclose}',NULL)";
				$result = mysql_query($query) or die(mysql_error());
				print $query;

				//insert into the department table
				$query = "insert into departments values(null,'{$job_id}','{$summary}','{$description}','{$conditions}','{$ex}','{$ed}')";
				$result = mysql_query($query2) or die(mysql_error());
				print $query;

 

any help please what am i doing wrong?

 

THanks in advance.

 

[revraz]

Your second query variable is wrong, it should be

 

$query2=

 

Right now its just $query=

[ROCKINDANO]

but it still doesn't update the second table.

[revraz]

echo $query and $query2 and check the strings.

[ROCKINDANO]

i did and still nothing. it echos out the info that i'm trying to submit but nothing when viewing the second table.

[revraz]

Post the echo's and both table structures.

[ROCKINDANO]

this is the echo

 

INSERT INTO fulltime VALUES (' title','pay','jobq','date',null)insert into departments values(null,'','summary','equipment','conditions','example','education')

 

the table structures are

 

fulltime (department, pay, jobnum, dateclose, job_id)

job_id is the primary key in this table

 

second table

departments (dept_id, job_id, summary, description, conditions, ex, ed)

dept_id is the primary key in this table

job_id is the foreign key from fulltime

 

another thing i notice is that when i fill the form out and click submit, it inserts all info to both tables but the job_id doesnt go into the second table. i found out this by checking the tables on phpmyadmin

[ROCKINDANO]

for some reason it does not get the job_id from the fulltime table

[ROCKINDANO]

why wouldn't it get the job_id from the fulltime table or pass it to the second query?

[fenway]

Let's see both queries echo'd please.