Error updating DB

[garethhall]

I am trying to update the DB but I keep in getting the "Sorry there was an error updating the photos table" message. Funny thing is if I prevent the first update query to run then it updates the DB fine? Anyone know way it's doing that?

 

 

<?php
if(isset($_POST['confirm']) && isset($_GET['invID'])){
$SQLupdate = "UPDATE invoiceDetail SET dState = '1' WHERE invoiceId = $invID AND dState = '2' OR dState = '3'";
$update = mysql_query($SQLupdate, $admin);
if($update){
	// Update photo table and set image state
	$SQLph = "SELECT photoId FROM invoiceDetail WHERE invoiceId = $invID AND dState = '3'";
	$rsPH = mysql_query($SQLph,$admin);
	while($rwPH = mysql_fetch_assoc($rsPH)){
		$phID = $rwPH['photoId'];
		$sql_updatePH = "UPDATE photos SET saleState = '3' WHERE photoID = '$phID'";
		$updatePH = mysql_query($sql_updatePH,$admin);
	}
	if($updatePH){
		header("Location: ". $approveURL);
	}else{
		echo "Sorry there was an error updating the photos table";	
	}
}else{
	echo "Sorry there was an error updating the invoice details table";	
}
}
?>

[Adam]

Use mysql_error() to find the error returned. Generally this will help you solve the problem straight away.