In order o update fields without using a UPDATE statement you have to use a cursor. In general, this is how ADO (the technology used by ASP) performs its updates in the manner you outlined below. There are no extensions bundled with PHP of which I am aware that allow you to update data via a cursor. -- bob On Mon, 9 Jun 2003, Steve B. wrote: > Hi > in asp it lets me say > ~get a record into dbrec which is a database object. > dbrec['field1'] = 'wow' > dbrec.update; > > is there no way to do this in linux? > thats lame if it is then that means my 25 web sites have to be re-written to work on Linux. > > > --- Becoming Digital <subs@becomingdigital.com> wrote: > > I assume you lack update permissions, which means you probably don't have the > > other permissions necessary to change data. Assuming you actually do, you could > > use REPLACE or DELETE followed by INSERT. > > > > Edward Dudlik > > Becoming Digital > > www.becomingdigital.com > > > > > > ----- Original Message ----- > > From: "Steve B." <stylinsty@yahoo.com> > > To: <php-db@lists.php.net> > > Sent: Monday, 09 June, 2003 19:29 > > Subject: how to update field without using UPDATE query? > > > > > > how to update field without using UPDATE query? > > > > I open the db at a certain ID then set > > $dbrec['field'] = new value > > How do you update the db? > > Thanks > > -steve > > > > > > > > --------------------------------- > > Do you Yahoo!? > > Free online calendar with sync to Outlook(TM). > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > __________________________________ > Do you Yahoo!? > Yahoo! Calendar - Free online calendar with sync to Outlook(TM). > http://calendar.yahoo.com > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php