RE: Not updating certain fields in same row

[Miguel Guirao <miguel.guirao@xxxxxxxxxxxxxxx>]

You can't use the function empty() because as soon as the form is submitted,
the value of an empty field in the form, is a blank in the variable in your
script, so basically your password field is NOT empty, it has a value, a
blank.

So you need to test your password field to NOT to be empty, also use a
second password field, a confirmation field, so:

$querystring="your SQL statement here";
If (passwd1 is not blank) and (passwd1==passwd2) then
	$querystring.="passwd='passwd1'"
If not
	You keep intact your first SQL statement without touching the passwd
field

My two niquel cents!
__________________
Miguel Guirao Aguilera, Linux+, ITIL
Sistemas de Información
Informática R8
Ext. 7540

--> -----Original Message-----
--> From: Jason Pruim [mailto:japruim@xxxxxxxxxx]
--> Sent: Tuesday, March 25, 2008 11:14 AM
--> To: Daniel Brown
--> Cc: php-db@xxxxxxxxxxxxx
--> Subject: Re:  Not updating certain fields in same row
--> 
--> 
--> On Mar 25, 2008, at 1:09 PM, Daniel Brown wrote:
--> > On Tue, Mar 25, 2008 at 12:59 PM, Jason Pruim <japruim@xxxxxxxxxx>
--> > wrote:
--> >> Hi everyone,
--> >>
--> >> I am attempting to update a record for a login system while leaving
--> >> certain fields untouched if they arn't changed, and am running into
--> >> issues.
--> > [snip!]
--> >>
--> >> I have tried this code:
--> >>                $tab = "\t";
--> >>        if (!isset($_POST['txtLoginName']) ||
--> >> empty($_POST['txtLoginName'])) {
--> >>
--> >>                        $loginName =
--> >> mysqli_real_escape_string($chpwpostlink,
--> >> $_POST['txtLoginName']);
--> >>                }
--> >>                else
--> >>                {
--> >>                        $loginName = $tab;
--> >>                }
--> >
--> >    Mmm-hmm.... and exactly how do that work to update the database?
--> > The SQL query you're probably looking for would be like this:
--> >
--> >    $sql = "UPDATE users SET
--> > Field1
--> > =
--> > '".mysql_real_escape_string
--> > ($field1)."',Field3='".mysql_real_escape_string($field3)."'
--> > WHERE id='".mysql_real_escape_string($id)."' LIMIT 1";
--> 
--> the actual query I'm using is this:
--> 
--> 	$chpwsql = "UPDATE current SET customerName='$customerName',
--> loginName='$loginName', loginPassword='$PW', email='$email',
--> adminLevel='$adminLevel' WHERE Record='$Record1'";
--> 
--> What it is doing now is if I don't set a a field I am replacing the
--> content of it with a tab, which isn't what I want. Basically what I'm
--> looking for is if loginPassword hasn't changed... don't clear the
--> contents of it. if it has changed, then update loginPassword
--> 
--> 
--> >
--> >
--> > --
--> > </Daniel P. Brown>
--> > Forensic Services, Senior Unix Engineer
--> > 1+ (570-) 362-0283
--> >
--> > --
--> > PHP Database Mailing List (http://www.php.net/)
--> > To unsubscribe, visit: http://www.php.net/unsub.php
--> >
--> >
--> 
--> --
--> 
--> Jason Pruim
--> Raoset Inc.
--> Technology Manager
--> MQC Specialist
--> 3251 132nd ave
--> Holland, MI, 49424-9337
--> www.raoset.com
--> japruim@xxxxxxxxxx
--> 
--> 
--> 
--> 
--> --
--> PHP Database Mailing List (http://www.php.net/)
--> To unsubscribe, visit: http://www.php.net/unsub.php


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