Do you have any kind of warning or error message when executing the update query?
Use mysql_error() to get an error message, if there is one. This will help in pinpointing the exact source of the problem. Olivier At 17:35 2002-05-10 +0100, James Mansfield wrote: >Beginner question this one (me being a designer and all) but it has been >doing my head in for a few hours now so I thought I would put it to the >group. > >I am trying to create a very simple database to keep track of my business >expenses - and all to further learn PHP - but am stuck. The following update >doe snot work and I have no idea why. If I change it to an INSERT it works >(ie creates a new entry) but the update is working. Any ideas on where I >should be looking for the problem?? > > $sqlQuery = "UPDATE $db_table SET Date = '$date', Company = '$company', >Description = '$description', Amount = '$amount', PaidBy='$paidBy', >ReImburse='$reImburse', ReIMburseDate='reImburseDate', Note = '$note' WHERE >id='$id'"; > >Thanx in advance >James > > > >-- >PHP Windows Mailing List (http://www.php.net/) >To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
