PHP/Mysql update syntax

[PaulLFC]

Hi, I am writing a booking system for a Paintball company I work for here in the UK, and I seem to be having trouble with the mysql UPDATE code.

Althogh no errors show, the mysql_affected_rows function returns -1 when I run the script.

Am I missing anything or is there an error in my code, I have been scratching my head over this all day and any help off you guys would be highley appreciated.

My Update script is:

<?

$id=$_GET['id'];
$date=$_GET['date'];

include("files/sql.connect.php");

$name=$_POST['name'];
$telephone=$_POST['telephone'];
$email=$_POST['email'];
$players=$_POST['players'];
$amountpaid=$_POST['amountpaid'];
$paytype=$_POST['paytype'];
$amountdue=$_POST['amountdue'];
$package=$_POST['package'];
$notes=$_POST['notes'];
$address=$_POST['address'];
$amountdue=0;

$query = 'UPDATE `northwestp`.`booking_system` SET `name` = \'$name\', `telephone` = \'$telephone\', `email` = \'$email\', `players` = \'$players\', `amountpaid` = \'$amountpaid\', `paytype` = \'$paytype\', `amountdue` = \'$amountdue\', `date` = \'$date\', `package` = \'$package\', `notes` = \'$notes\', `address` = \'$address\' WHERE `booking_system`.`bookid` = \'$id\' LIMIT 1;';

echo(mysql_affected_rows()); // put in to try and figure out the error


mysql_query($query) or die("Error: ".mysql_error());
echo("<font face=\"Arial\" size=\"3\">Record Updated.</font><hr>");
echo "<form>
<input type=button value=\"Close This Window\" onClick=\"javascript:window.close();\">
</form>
";
mysql_close();

?>

Any help would be greatly appreciated, Thanks in advance.

[code green]

mysql_affected rows will do nothing here because you have not executed the query.
Should be [PHP]$result = mysql_query($query);
echo mysql_affected rows($result);[/PHP]Remove the semi colon from the end of the query string.
And please get rid of the ugly escape quotes.
Either place full query in double quotes or use concatenation.

[PaulLFC]

Hi, I changed the query to

$query = "UPDATE `northwestp`.`booking_system` SET `name` = '$name', `telephone` = '$telephone', `email` = '$email', `players` = '$players', `amountpaid` = '$amountpaid', `paytype` = '$paytype', `amountdue` = '$amountdue', `date` = '$date', `package` = '$package', `notes` = '$notes', `address` = '$address' WHERE `booking_system`.`bookid` = '$id' LIMIT 1;";

and changed the affected row function to


$query0=mysql_query($query);

echo(mysq_affected_rows($query0));


and I got

Warning: mysql_affected_rows(): supplied argument is not a valid MySQL-Link resource in /home/fhlinux200/n/northwestpaintball.co.uk/user/htdocs/booking_system/update.php on line 25

sorry if im missing the obvious, I have been at this all day with no luck

[code green]

Sorry my mistake.
mysql_affected_rows() expects the link ID not the result ID.
You can pass an empty parameter and it will assume the last link ID.
Obviously it cannot count the number of rows before the query has been executed