CANT YOU SEE WHERE IM GOING WRONG ANYONE?? HELP PLEASE

[jigsawsoul]

I don't get an mysql or php error message. and $apologiesid, $occurrenceid and $staffid are all carry the right information from my testing. but yet it still goes to the else part of the statement. can anyone see why???

 

$query = "INSERT INTO web_roles (apologies_id) VALUES ('$apologiesid') WHERE occurrence_id = '$occurrenceid' AND staff_id = '$staffid'";

if (mysql_query ($query)) {
 $_SESSION['message'] = "
		<div class='notification success png_bg'>
			<a href='#' class='close'><img src='http://stuweb.cms.gre.ac.uk/~hr728/_web/_resources/images/icons/cross_grey_small.png' title='Close this notification' alt='close' /></a>
			<div>
				Your apologies have been sent...
			</div>
		</div>";
		header('Location: list.php');
} 
else {
$_SESSION['message'] = "
		<div class='notification error png_bg'>
			<a href='#' class='close'><img src='http://stuweb.cms.gre.ac.uk/~hr728/_web/_resources/images/icons/cross_grey_small.png' title='Close this notification' alt='close' /></a>
			<div>
				Error. please can't admin
			</div>
		</div>";
		header('Location: list.php');
}

 

[attachment deleted by admin]

[jigsawsoul]

$query = "INSERT INTO web_roles (apologies_id) VALUES ('$apologiesid') WHERE occurrence_id = '$occurrenceid' AND staff_id = '$staffid'";

 

Can anyone see anything wrong with this line of code. ??

[wildteen88]

No, but to see if your query is failing due to an error use mysql_error.

[jigsawsoul]

i get this 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 'WHERE occurrence_id = '35' staff_id = '8'' at line 1

 

any idea where the problem lays.. as i still can't find it.

[jigsawsoul]

as you guys can see it relates to right data in the web_roles table, in the image

 

[attachment deleted by admin]

[wildteen88]

$query = "INSERT INTO web_roles (apologies_id) VALUES ('$apologiesid') WHERE occurrence_id = '$occurrenceid' AND staff_id = '$staffid'";

 

Can anyone see anything wrong with this line of code. ??

DOH! I didn't read your query properly. INSERT statements do not have a WHERE clause.

 

Are you inserting a new record or are you wanting to update an existing record? For updating existing records you should use an UPDATE query.