sql how capture on the fly the row's id when is updated

Path	csiph.com!usenet.pasdenom.info!aioe.org!.POSTED!not-for-mail
From	alex <alex@nomailno.it>
Newsgroups	comp.lang.php
Subject	sql how capture on the fly the row's id when is updated
Date	Sat, 01 Aug 2015 11:15:52 +0200
Organization	Aioe.org NNTP Server
Lines	33
Message-ID	<mpi2nt$gpp$1@speranza.aioe.org> (permalink)
NNTP-Posting-Host	BRk/I5qPPVaaTWj1DtjEYw.user.speranza.aioe.org
Mime-Version	1.0
Content-Type	text/plain; charset=iso-8859-15; format=flowed
Content-Transfer-Encoding	8bit
X-Complaints-To	abuse@aioe.org
User-Agent	Mozilla/5.0 (Windows NT 6.1; WOW64; rv:31.0) Gecko/20100101 Thunderbird/31.7.0
X-Notice	Filtered by postfilter v. 0.8.2
Xref	csiph.com comp.lang.php:15617

Show key headers only | View raw

UPDATE  a AS a
  INNER JOIN c AS c  ON  a.id = c.id
  SET     a.total = 1
  WHERE b.x < c.y



this sql, in the table a total's field, insert the value 1 under certain 
conditions; in some rows the value already exists and will only insert 
in other lines;
is possible put in an array php only the id of the rows updated?

es nel caso sotto su 1  6 ho già il valore; con sql vado a d inserire
solo nella riga 3

example
table a
id     total
1       1 already there is
2	0
3	0 only here the sql will insert the new value
4	0
5	0
6	1 already there is
7	0
...
1000	0


I think is necessary, while sql loop the rows, when a row is updated,
capture the id and insert in the php array, but how?

..........................................................................

Back to comp.lang.php | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

sql how capture on the fly the row's id when is updated alex <alex@nomailno.it> - 2015-08-01 11:15 +0200
  Re: sql how capture on the fly the row's id when is updated Denis McMahon <denismfmcmahon@gmail.com> - 2015-08-01 14:51 +0000
  Re: sql how capture on the fly the row's id when is updated "Peter H. Coffin" <hellsop@ninehells.com> - 2015-08-01 10:03 -0500
  Re: sql how capture on the fly the row's id when is updated Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2015-08-01 20:33 +0200
  Re: sql how capture on the fly the row's id when is updated Matthew Carter <m@ahungry.com> - 2015-08-01 15:44 -0400
    Re: sql how capture on the fly the row's id when is updated alex <alex@nomailno.it> - 2015-08-01 22:01 +0200
      Re: sql how capture on the fly the row's id when is updated Matthew Carter <m@ahungry.com> - 2015-08-01 16:13 -0400
        Re: sql how capture on the fly the row's id when is updated alex <alex@nomailno.it> - 2015-08-02 01:51 +0200
          Re: sql how capture on the fly the row's id when is updated Matthew Carter <m@ahungry.com> - 2015-08-01 21:38 -0400
    Re: sql how capture on the fly the row's id when is updated Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2015-08-02 14:42 +0200
      Re: sql how capture on the fly the row's id when is updated alex <alex@nomailno.it> - 2015-08-04 19:24 +0200
        Re: sql how capture on the fly the row's id when is updated Matthew Carter <m@ahungry.com> - 2015-08-04 14:55 -0400
          Re: sql how capture on the fly the row's id when is updated alex <alex@nomailno.it> - 2015-08-05 01:13 +0200
        Re: sql how capture on the fly the row's id when is updated Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2015-08-04 21:29 +0200
          Re: sql how capture on the fly the row's id when is updated alex <alex@nomailno.it> - 2015-08-05 01:01 +0200
            Re: sql how capture on the fly the row's id when is updated alex <alex@nomailno.it> - 2015-08-05 01:03 +0200
            Address munging considered harmful (was: sql how capture on the fly the row's id when is updated) Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2015-08-05 10:08 +0200

csiph-web