[PHP-DB] adding to the current value

2005-09-29 Thread Justin Turner
I would like to increment the current value of a field X without having to retrieve field X beforehand. Can I do this? Example: UPDATE my_table set field_1 = (current_field_value -1) WHERE...blah, blah, blah == A. Justin Turner -- PHP

Re: [PHP-DB] adding to the current value

2005-09-29 Thread Justin Turner
How can I do this? Bastien Koert wrote: yes From: Justin Turner [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] adding to the current value Date: Thu, 29 Sep 2005 16:26:00 -0400 I would like to increment the current value of a field X without having to retrieve field X

Re: [PHP-DB] adding to the current value

2005-09-29 Thread Justin Turner
messing with a production system, you could always just try out simple stuff like this on your own and see what happens. More fun that way anyhow. Rich -Original Message- From: Justin Turner [mailto:[EMAIL PROTECTED] Sent: Thursday, September 29, 2005 5:04 PM To: Bastien Koert Cc: php-db

[PHP-DB] Lock Tables Privileges

2005-08-15 Thread Justin Turner
I have tried several times to create a user that has the ability to lock and unlock tables, but to no avail. Am I missing something? I tried creating a user with all privileges to a database and still the user does not have the ability to lock/unlock tables within that database. GRANT ALL