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