Home

Fix for UPDATE statement

December 25, 2009 - 8:32am — simonsays1980
  1. case 'update':
  2.                         $query = "SELECT languages, skype, msn, icq, mobile, telephone, address, zipcode, website, interests, clubs, advicedwebsites"
  3.                         ."  FROM {profileadds} WHERE uid = %d";
  4.                         $result = db_query($query, $account->uid);
  5.                        
  6.                         if(db_fetch_object($result)) {
  7.                                 $query = "UPDATE {profileadds} SET languages = '%s', skype = '%s', msn = %d, icq = '%s', mobile = '%s', telephone = '%s', address = '%s',"
  8.                                 ."zipcode = '%s', website = '%s', interests = '%s', clubs = '%s', advicedwebsites = '%s' WHERE uid = %d";
  9.                                 db_query($query, $edit['languages'], $edit['skype'], $edit['msn'], $edit['icq'], $edit['mobile'],
  10.                           $edit['phone'], $edit['address'], $edit['zipcode'], $edit['websites'], $edit['interests'], $edit['clubs'],
  11.                           $edit['job'], $edit['advicedwebsites'], $account->uid);
  12.                         }
  13.                         else {
  14.                                 db_query("INSERT INTO {profileadds} (uid, languages, skype, msn, icq, mobile, telephone, address, zipcode, websites, interests, clubs, job, advicedwebsites)"
  15.                           ." VALUES (%d, '%s', '%s', %d, '%s','%s','%s','%s',%d,'%s','%s','%s','%s','%s')",
  16.                           $account -> uid, $edit['languages'], $edit['skype'], $edit['msn'], $edit['icq'], $edit['mobile'],
  17.                           $edit['phone'], $edit['address'], $edit['zipcode'], $edit['websites'], $edit['interests'], $edit['clubs'],
  18.                           $edit['job'], $edit['advicedwebsites']);
  19.                         }

Submit Fix

Any tags you'd like to associate with your code, delimitered by commas (example: Views, CCK, Module, etc).
Select the syntax highlighting mode to use.