TalkPHP - View Single Post

Tanax · 09-20-2007, 12:57 PM

So in my example, it would look like this?

PHP Code:


			
$sql = sprintf("INSERT INTO
    %s
    (uid, username, password, registerdate, registerip)
VALUES
    ('NULL', '%s', '%s', '%s', '%s')
ON DUPLICATE KEY
UPDATE
    username = '%s',
        password = '%s',
        registerdate = '%s',
        registerip = '%s'",
$this->table['members'],
$this->data['username'],
$this->data['password'],
$this->data['registerdate'],
$this->data['registerip']);

$this->db->query($sql);

09-20-2007, 12:57 PM	#11 (permalink)
Tanax The Prestige Join Date: Sep 2007 Location: Sweden, Stockholm Posts: 1,080 Thanks: 115	So in my example, it would look like this? PHP Code: `$sql = sprintf("INSERT INTO %s (uid, username, password, registerdate, registerip) VALUES ('NULL', '%s', '%s', '%s', '%s') ON DUPLICATE KEY UPDATE username = '%s', password = '%s', registerdate = '%s', registerip = '%s'", $this->table['members'], $this->data['username'], $this->data['password'], $this->data['registerdate'], $this->data['registerip']); $this->db->query($sql);`