Line of Code...

[eternally1027]

I apologize for having to post this line of code, but I have an issue with it and I can't seem to resolve it.

Here is the line of code:

$finished1 = mysql_query("INSERT INTO guests_old(ticketnumber, customername, customerphone, datecheckin, computerlocation) VALUES('$_POST[ticket]','$_POST[name]', '$_POST[phone]', '$_POST[checkin]', '$_POST[location]'") or die(mysql_error());

and here is the MySQL 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 '' at line 1

Thank you for your help!

Also, here is the whole PHP Script in case it helps to explain my situation.

<?
	$conedit = mysql_pconnect("localhost","ethanwe_ethan","password")
                   or die("Unable to connect to SQL server");
    mysql_select_db("ethanwe_timpc", $conedit) or die("Unable to select database");
	$editdata = mysql_query("UPDATE guests SET customername='$_POST[name]', customerphone='$_POST[phone]', datecheckin='$_POST[date]', computerlocation='$_POST[location]' WHERE ticketnumber = '$_POST[ticket]'") or die("Hey");
	$finished1 = mysql_query("INSERT INTO guests_old(ticketnumber, customername, customerphone, datecheckin, computerlocation) VALUES('$_POST[ticket]','$_POST[name]', '$_POST[phone]', '$_POST[checkin]', '$_POST[location]'") or die(mysql_error());
	$finished2 = mysql_query("DELETE FROM guests WHERE ticketnumber = '$_POST[ticket]'") or die("Unable to write to database2");
	if ($_POST[edit]){
			mysql_query($editdata);
			}
	else if ($_POST[finished]){
			mysql_query($finished1) or die(mysql_error());
			//mysql_query($finished2) or die('3mysql_error()');
		}
	?>

[laserlight]

Check for matching parentheses.

[eternally1027]

Okay, That is resolved. Thanks!

However...Now that 'IF' is not functioning correctly. I just had a row get deleted that have been updated (the $editdata call).

Here is how the code currently looks.

<?
	$conedit = mysql_pconnect("localhost","ethanwe_ethan","password")
                   or die("Unable to connect to SQL server");
    mysql_select_db("ethanwe_timpc", $conedit) or die("Unable to select database");
	$editdata = mysql_query("UPDATE guests SET customername='$_POST[name]', customerphone='$_POST[phone]', datecheckin='$_POST[date]', computerlocation='$_POST[location]' WHERE ticketnumber = '$_POST[ticket]'") or die("Hey");
	$fin = mysql_query("INSERT INTO guests_old(ticketnumber, customername, customerphone, datecheckin, computerlocation) VALUES('$_POST[ticket]','$_POST[name]', '$_POST[phone]', '$_POST[checkin]', '$_POST[location]')");
	$fini = mysql_query("DELETE FROM guests WHERE ticketnumber = '$_POST[ticket]'");


if(isset($_POST['finished'])){

mysql_query($fin) or die(mysql_error());
mysql_query($fini) or die(mysql_error());

}
if(isset($_POST['edit'])){

mysql_query($editdata);

}
	?>

This script is called by a form which uses two different submit buttons:

<INPUT TYPE=SUBMIT NAME="edit" VALUE="edit">
<INPUT TYPE=SUBMIT NAME="finished" VALUE="finished">

No matter which button I press, the 'finished' section is being called, and thus deleting my table entry even if it was supposed to just be editing it. Shouldn't these trigger the IF statement correctly?

[redrage]

accually it looks like they're both being called because they're both set. finished gets processed first since it is frist in the code. (i think) try taking out <input type .... value="finished"> and see if it the edit works.

at least then you know the problem isn't php.

[rincewind456]

The thing is your executing the queries twice, once before the IF statement and then again during the IF. I've marked them with arrows.

<?
	$conedit = mysql_pconnect("localhost","ethanwe_ethan","password")
                   or die("Unable to connect to SQL server");
    mysql_select_db("ethanwe_timpc", $conedit) or die("Unable to select database");

---------->$editdata = mysql_query("UPDATE guests SET customername='$_POST[name]', customerphone='$_POST[phone]', datecheckin='$_POST[date]', computerlocation='$_POST[location]' WHERE ticketnumber = '$_POST[ticket]'") or die("Hey");

---------->$fin = mysql_query("INSERT INTO guests_old(ticketnumber, customername, customerphone, datecheckin, computerlocation) VALUES('$_POST[ticket]','$_POST[name]', '$_POST[phone]', '$_POST[checkin]', '$_POST[location]')");

---------->$fini = mysql_query("DELETE FROM guests WHERE ticketnumber = '$_POST[ticket]'");


if(isset($_POST['finished'])){

---------->mysql_query($fin) or die(mysql_error());
---------->mysql_query($fini) or die(mysql_error());

}
if(isset($_POST['edit'])){

---------->mysql_query($editdata);

}
	?>