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@raoset.com> 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@raoset.com