Re: [PHP] Adding to a MySql Database

2002-09-24 Thread Justin French
on 25/09/02 3:05 AM, The New Source ([EMAIL PROTECTED]) wrote: > I have a field on a MySql database that is started with a 0, and I want > to add 1 to this field every time a button is pressed on a form. So it > should add one every time, like if there is 5 and you press it one time > it would ha

Re: [PHP] Adding to a MySql Database

2002-09-24 Thread John S. Huggins
On Tue, 24 Sep 2002, The New Source wrote: >-I have a field on a MySql database that is started with a 0, and I want >-to add 1 to this field every time a button is pressed on a form. So it >-should add one every time, like if there is 5 and you press it one time >-it would have 6. >- UPDATE tab

Re: [PHP] Adding to a MySql Database

2002-09-24 Thread Daniel Masson
I agree mt, LET MYSQL DO THE JOB !! > > Marek's a bit more elegant, but I'm wondering when twelve of us press > the button and the database is hit bang, bang, bang. Mightn't a MySQL > autoincrement field be better, and let MySQL do the work? > > mt > > At 07:32 PM 9/24/2002 +0200, Marek Kilimaje

Re: [PHP] Adding to a MySql Database

2002-09-24 Thread Miles Thompson
Marek's a bit more elegant, but I'm wondering when twelve of us press the button and the database is hit bang, bang, bang. Mightn't a MySQL autoincrement field be better, and let MySQL do the work? mt At 07:32 PM 9/24/2002 +0200, Marek Kilimajer wrote: >Or better UPDATE table SET col = col +1

Re: [PHP] Adding to a MySql Database

2002-09-24 Thread Marek Kilimajer
Or better UPDATE table SET col = col +1 Jay Blanchard wrote: >[snip] >I have a field on a MySql database that is started with a 0, and I want >to add 1 to this field every time a button is pressed on a form. So it >should add one every time, like if there is 5 and you press it one time >it would

RE: [PHP] Adding to a MySql Database

2002-09-24 Thread Jay Blanchard
[snip] I have a field on a MySql database that is started with a 0, and I want to add 1 to this field every time a button is pressed on a form. So it should add one every time, like if there is 5 and you press it one time it would have 6. [/snip] 1. SELECT for the current value 2. add 1 to the cu

[PHP] Adding to a MySql Database

2002-09-24 Thread The New Source
I have a field on a MySql database that is started with a 0, and I want to add 1 to this field every time a button is pressed on a form. So it should add one every time, like if there is 5 and you press it one time it would have 6.