Delimiter problem (I think)

K0108788

Hi All,

I have the following queries:

$query_SP = 	"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'] . "'); "; 

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

But keeping getting the following error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; INSERT INTO project_assess (project_assess_ID, project_ID, LK_ID) ' at line 4

devinemke

are you perhaps trying to run both of these queries in a single call to [man]mysql_query[/man]?

K0108788

No, they are both executed seperately

$query_SP = 	"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'] . "'); ";

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

$query = $query_SP.$query_PA; 
$result = mysql_query($query) 
or die(mysql_error());

K0108788

You may be right. How can I get these queries to work rather than using the single mysql_query call?

devinemke

K0108788 wrote:
No, they are both executed seperately

no you're not, you are concatenating the two queries together and running them with one call to mysql_query(). that is the problem.

K0108788

How can I solve that problem?

devinemke

K0108788 wrote:
How can I solve that problem?

make two separate calls to [man]mysql_query[/man]