On Mar 25, 2008, at 1:09 PM, Daniel Brown wrote:
On Tue, Mar 25, 2008 at 12:59 PM, Jason Pruim <[EMAIL PROTECTED]> 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

I have tried this code:
               $tab = "\t";
if (!isset($_POST['txtLoginName']) || empty($_POST['txtLoginName'])) {

$loginName = mysqli_real_escape_string($chpwpostlink,
                       $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

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

Reply via email to