Re: [PHP] Adjust two or more mysql rows ?

2004-08-11 Thread Jason Davidson
Yup, confused me... what is it for? J Dave Carrera [EMAIL PROTECTED] wrote: Hi List, I have a qty posted via a form field, lets say 46. In my mysql table I have two rows which I want to reduce their qty fields. 1 row has a qty of say 13 and the second has a qty of 50, making 63 in

RE: [PHP] Adjust two or more mysql rows ?

2004-08-11 Thread Dave Carrera
that helps Dave Carrera -- UK Web Hosting @ http://www.ephgroup.com -Original Message- From: Jason Davidson [mailto:[EMAIL PROTECTED] Sent: 11 August 2004 19:00 To: Dave Carrera; [EMAIL PROTECTED] Subject: Re: [PHP] Adjust two or more mysql rows ? Yup, confused me... what

Re: [PHP] Adjust two or more mysql rows ?

2004-08-11 Thread John Holmes
Dave Carrera wrote: I have a qty posted via a form field, lets say 46. In my mysql table I have two rows which I want to reduce their qty fields. 1 row has a qty of say 13 and the second has a qty of 50, making 63 in total. So I would like to say something like if $_POST[qty] is greater than row

RE: [PHP] Adjust two or more mysql rows ?

2004-08-11 Thread Ed Lazor
I don't think you can have a single mysql query do what you're wanting. Break it into mutiple queries. -Original Message- Hi List, I have a qty posted via a form field, lets say 46. In my mysql table I have two rows which I want to reduce their qty fields. 1 row has a qty of

RE: [PHP] Adjust two or more mysql rows ?

2004-08-11 Thread Ed Lazor
-Original Message- From: Dave Carrera [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 11, 2004 11:14 AM To: 'Jason Davidson' Cc: [EMAIL PROTECTED] Subject: RE: [PHP] Adjust two or more mysql rows ? I am deving a goods in system that REQUIRES that each delivery of items

Re: [PHP] Adjust two or more mysql rows ?

2004-08-11 Thread John Holmes
Dave Carrera wrote: I am deving a goods in system that REQUIRES that each delivery of items be entered into raw stock separately. This is why two rows in the table have identical details like, Supplier Product name But the qtys may be diff. Ect ect Now the PREPARATION dept need to internally order

RE: [PHP] Adjust two or more mysql rows ?

2004-08-11 Thread Dave Carrera
- From: Jason Davidson [mailto:[EMAIL PROTECTED] Sent: 11 August 2004 19:26 To: Dave Carrera Subject: RE: [PHP] Adjust two or more mysql rows ? ok, i understand better, so you have a good idea of what your doing by looks of it, i guess your trying to get some opinionis on the best way of doing

RE: [PHP] Adjust two or more mysql rows ?

2004-08-11 Thread Jason Davidson
PROTECTED] Sent: 11 August 2004 19:26 To: Dave Carrera Subject: RE: [PHP] Adjust two or more mysql rows ? ok, i understand better, so you have a good idea of what your doing by looks of it, i guess your trying to get some opinionis on the best way of doing this? so, to make your query