Re: adding records

Hi Theo > I use a PHP script to add records to my database. It usually works very > good, but from time to time it refuses. > I enter my data through a data entry form. After I tell it to add the record > it normally displays the data to be added shortly and then my data entry > form reappears. > Frequently however the data stay on screen - in two versions, one below the > other - and the data entry form doesnt reappear. Instead I am told that > something went wrong and that I should push the back key and alter the data > manually. Doing that brings me back to the normal data entry form with my > data in it - not twice - everything looks normal. Data entry remains > impossible. What is wrong here? Without seeing your code, the database structure and the data you're trying to put into the database, one can only speculate... a) Perhaps a datatype you're trying to submit is incorrect or duplicates an existing record, so the database is rejecting it. b) Perhaps there's validation code inside the PHP script before it does the insert and the data you're trying to enter fails one or more of the validation tests. c) The computer is feeling persnickitey. :) --Dan -- T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y More than just answers. Solutions. (SM) http://www.analysisandsolutions.com/ 4015 7 Av #4, Brooklyn NY 11232 v: 718-854-0335 f: 718-854-0409