Hi, I changed the query to

$query = "UPDATE `northwestp`.`b ooking_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...

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...