Re: Replace/Update record in dbase using dbase_replace_record()

Rahul Sitaram Johari wrote: > Ave, > > Can¹t figure this one out. I¹m using the dbase_replace_record() function to > replace a record in a dbase (.dbf) database. I just want to replace the > value of one of the fields with another value. This is my code: > > $db = dbase_open("CRUMBS.DBF", 2) or die("Fatal Error: Could not open > database!"); > if ($db) { > $record_numbers = dbase_numrecords($db); > for ($i = 1; $i <= $record_numbers; $i++) { > $row = dbase_get_record_with_names($db, $i); > if ($row['PHONE'] == $thekey) { > print_r($row); > $row['A'] == "F"; > dbase_replace_record($db, $row, 1); > } > } > } > dbase_close($db); > > Basically I have a database called ³CRUMBS.DBF², and the record where PHONE > = $thekey, I want to replace the value of the field ³A² with ³F². I keep > getting the error: ³Wrong number of fields specified². > I have over 60 fields in each row ­ and I just want to replace the value of > the field ³A². > > Any suggestions? get a big jar of 'clue'. as in learn to investigate and read ... not having ever used these functions here are my hypotheses based on 5 seconds of investigation and reading: 1. dbase_get_record_with_names() gives a assoc. array - it may also have fields as indexed items in that array (like other DB extensions often do) ergo double the fields that you want. 2. quoting the following page: http://php.net/dbase_get_record_with_names "Return Values An associative array with the record. This will also include a key named deleted which is set to 1 if the record has been marked for deletion" so dbase_replace_record() is possibly seeing 'deleted' as a extra erranous field. 3. maybe looking at and comparing the output of print_r($row), dbase_get_record_with_names($db, $i) and dbase_get_record($db, $i) might tell you something;