[RESOLVED] Update Query wont work

[blckspder]

Hello,
I have a form that updates one table and then inserts a row in another table... the update query however will not work....

Both update queries in this code will not update actually.. can someone please help?

<?php

//include database settings
include("../open_config.php");

//pull id number from url
$userid = $_GET['id'];
//pull information from table based on pulled id number
$select_id = "SELECT * FROM ticketMain LEFT JOIN userID ON ticketMain.userID=userID.IDnumber";
$id_query = mysql_query($select_id);
$pull_id = mysql_fetch_array($id_query);

//post data from form to be databased
$ticketNum = $_POST['ticketNum'];
$openDrop = $_POST['openDrop'];
$member = $_POST['member'];
$NatCode = $_POST['NatCode'];
$SubNatCode = $_POST['SubNatCode'];
$prorecur = $_POST['prorecur'];
$endDate = $_POST['endDate'];

if(isset($_POST['submit'])) {
	//if open drop equals the date then open the ticket
	if($openDrop == date("Y-m-d")) {
		mysql_query("UPDATE ticketMain SET openDate='$openDrop', problemRec='$prorecur' ticNatCode='$NatCode' WHERE ticketNum=$ticketNum");
		mysql_query("INSERT INTO tickStaffAssign (ticketNum, staffAssign, dateStart) VALUES ('$ticketNum','$member','$openDrop')");
		}
	if($openDrop == "drop") {
		mysql_query("UPDATE ticketMain SET closeDate='$endDate', closeStat='Dropped' WHERE ticketNum=$ticketNum");
		}
	}

?>

[blckspder]

I took a different approach thanks anyways

[nnichols]

You should add some debug code to your queries so you can figure out for yourself what is going on -

$sql = "UPDATE ticketMain SET openDate='$openDrop', problemRec='$prorecur' ticNatCode='$NatCode' WHERE ticketNum=$ticketNum";
mysql_query($sql)
    or die('<br />MySQL error: ' . mysql_error() . '<br />SQL: ' . $sql);

add debug lines in your code so that you can make sure that all the REQUEST variables contain what you expect -

print_r($_POST);
print_r($_GET);

Hope this helps you figure out what you're doing wrong 😉

[blckspder]

thanks ill try that