[PHP] MySQL question...not sure if this is the correct forum to ask.

2002-02-14 Thread Peter Ruan 

Hi,
  I have a quick MySQL question...if this is not the correct forum for
it, then someone please point me to the right one.

  Can the UPDATE statement have conditional check embedded in it?  I
have a page that displays a record (in a FORM format) that the user can
change the information on each column.  I want to check each column and
see which has been changed and update the table for entries that were
changed only.

for each column data {
  if column is changed
  then update;
  else
  do nothing;
}

Maybe I am making this too complicated than it needs and just go ahead
and update all of the columns regardless with the new values, regardless
they are actually different or not.

Thanks in advance,
-Peter




-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] MySQL question...not sure if this is the correct forum to ask.

2002-02-14 Thread DL Neil 

Peter,

   I have a quick MySQL question...if this is not the correct forum for
 it, then someone please point me to the right one.
 
   Can the UPDATE statement have conditional check embedded in it?  I
 have a page that displays a record (in a FORM format) that the user can
 change the information on each column.  I want to check each column and
 see which has been changed and update the table for entries that were
 changed only.
 
 for each column data {
   if column is changed
   then update;
   else
   do nothing;
 }
 
 Maybe I am making this too complicated than it needs and just go ahead
 and update all of the columns regardless with the new values, regardless
 they are actually different or not.


There is a MySQL list, and a separate PHP-DB list.

UPDATE is 'intelligent', it will only modify the row if there is something to change.

Regards,
=db



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php