Inserted data into 2 tables. But IDs don't match

K0108788

I have wrote the following queries but the values being entered into the table are not right (see tables below). The project_ID isn't the same in both tables:

if (isset($_POST['submit']) && $_POST['submit'] == "Create Project") {
     if ($_POST['lecturer_role'] != " " &&
     $_POST['SK_ID'] != " " &&
     $_POST['project_name'] != " "  &&
     $_POST['project_description'] != " ") {

      mysql_query("INSERT INTO student_project 
      (project_ID, lecturer_role, LK_ID, SK_ID, project_name, project_desc) 
      VALUES('$projectid', '" . $_POST['role'] . "', '" . $_SESSION['user_logged'] . "', 
      '" . $_POST['students'] . "', '" . $_POST['project_name'] . "',  
      '" . $_POST['project_desc'] . "') ") ;

      mysql_query("INSERT INTO project_assess
      (project_assess_ID, project_ID, LK_ID) 
      VALUES('$assessid', '$projectid', '". $_SESSION['user_logged'] ."') ") ;

STUDENT_PROJECT
project_ID LK_ID SK_ID lecturer_role project_name project_desc

3

4

PROJECT_ASSESS
project_assess_ID project_ID LK_ID
3 0

4 0

project_ID seems to get a value of 0 in the PROJECT_ASSESS table.

Can anyone help?

laserlight

That's very unusual. Print the value $projectid before, between and after the queries.

K0108788

I did the following and got NO values for $projectid on screen:

<?php
session_start();
include "conn.inc.php"; 

if (isset($_POST['submit']) && $_POST['submit'] == "Create Project") {
	if ($_POST['lecturer_role'] != " " &&
		$_POST['SK_ID'] != " " &&
		$_POST['project_name'] != " "  &&
		$_POST['project_description'] != " ") {

	echo $projectid;
      mysql_query("INSERT INTO student_project 
      (project_ID, lecturer_role, LK_ID, SK_ID, project_name, project_desc) 
      VALUES('$projectid', '" . $_POST['role'] . "', '" . $_SESSION    ['user_logged'] . "', 
      '" . $_POST['students'] . "', '" . $_POST['project_name'] . "',   
      '" . $_POST['project_desc'] . "') ") ; 
       echo $projectid;
      mysql_query("INSERT INTO project_assess 
      (project_assess_ID, project_ID, LK_ID) 
      VALUES('$assessid', '$projectid', '". $_SESSION['user_logged'] ."') ") ; 
		echo $projectid;
?>

laserlight

Perhaps you need to set:

$projectid = $_POST['projectid'];

or do something similiar.

But from the looks of it, you are using an autoincremented column for projectid.

<?php
session_start();
include "conn.inc.php";

if (isset($_POST['submit']) && $_POST['submit'] == "Create Project") {
	if ($_POST['lecturer_role'] != " " &&
		$_POST['SK_ID'] != " " &&
		$_POST['project_name'] != " "  &&
		$_POST['project_description'] != " ") {

	mysql_query("INSERT INTO student_project
		(project_ID, lecturer_role, LK_ID, SK_ID, project_name, project_desc)
		VALUES(NULL, '" . $_POST['role'] . "', '" . $_SESSION    ['user_logged'] . "',
		'" . $_POST['students'] . "', '" . $_POST['project_name'] . "',   
		'" . $_POST['project_desc'] . "') ") ;
	mysql_query("INSERT INTO project_assess
		(project_assess_ID, project_ID, LK_ID)
		VALUES('" . mysql_insert_id() . "', '$projectid', '". $_SESSION['user_logged'] ."') ") ;
?>

K0108788

What about using mysql_insert_id with $projectid? Would that ensure the project_ID carries the same values in both tables?

laserlight

What about using mysql_insert_id with $projectid? Would that ensure the project_ID carries the same values in both tables?

That's in my example.

K0108788

Would it help if I had a foreign key project_assess_ID in my student_project table?

laserlight

Oh, sorry, I made a typo in my example, but I'm sure you understand what I was trying to get at.

K0108788

What was the typo?

I don't understand how to pass the $projectid (project_ID) over from student_project to project_assess?

K0108788

The auto incremented value in student_project is project_ID ($projectid) and the auto_incremented in project_assess is project_assess_ID ($assessid). I don't know why the project_ID isn't being written to assess_project 🙁

laserlight

The typo is that you dont want to use mysql_insert_id() for the project_assess_ID column, but for the project_assess.project_ID column.