?

Search Help Board

PHP FAQ
PHP Articles
PHP Help
Bulletin Board
PHP Manual (NEW!)
First Time PHP'ers
Help with programming
Sql assignment help
PHP Homework Help


 ?
New Topic??|??Go to Top??|??Go to Topic??|??Flat View??|??Search?
?Previous Message??|??Next Message
?Re: decrement availability?
Author:??(---.dialsprint.net)
Date:???03-05-04 09:28

update tablename set fieldname = fieldname -1 where fieldname > 0


just to insure it doesnt go negative..
you can go into even more details.

update tablename set fieldname = fieldname -1 where fieldname > 0 AND fieldname = usernames

Reply To This Message
?Newer Topic??|??Older Topic

?Topics Author? Date
?decrement availability???new
Niz 03-04-04 08:20?
?Re: decrement availability???new
bastien 03-04-04 09:36?
?Re: decrement availability???new
Niz 03-04-04 14:59?
?Re: decrement availability???new
bastien 03-04-04 16:09?
?Re: decrement availability???new
mike... 03-05-04 09:28?
?Re: decrement availability???new
Niz 03-06-04 05:45?
Go to Top??|??Go to Topic??|??Flat View??|??Search?
??|??
New Topic
?Reply To This Message
?Your Name:
?Your Email:
?Subject:
Email replies to this thread, to the address above.
????

Provided By
Phorum