[SQL][PHP] Problem z zapytaniem do bazy Opcje

[Miszazdw]

[PHP] pobierz, plaintext 
$query = 'INSERT INTO USERS (USERNAME, PASSWORD, ' .
'EMAIL_ADDR, IMIE, NAZWISKO, PESEL, TEL_DOM, TEL_KOM, ' .
'REGON, NIP, ULICA, NR_DOMU, KOD_POCZTOWY, MIASTO, NAZWA_FIRMY' .
'IS_ACTIVE) '.
'VALUES (mysql_real_escape_string($this->username, $GLOBALS[\'DB\']), '.
'mysql_real_escape_string($this->password, $GLOBALS[\'DB\']), '.
'mysql_real_escape_string($this->emailAddr, $GLOBALS[\'DB\']),'.
'mysql_real_escape_string($this->imie, $GLOBALS[\'DB\']), '.
'mysql_real_escape_string($this->nazwisko, $GLOBALS[\'DB\']),'.
'mysql_real_escape_string($this->pesel, $GLOBALS[\'DB\']),'.
'mysql_real_escape_string($this->tel_dom, $GLOBALS[\'DB\']),'.
'mysql_real_escape_string($this->tel_kom, $GLOBALS[\'DB\']),'.
'mysql_real_escape_string($this->regon, $GLOBALS[\'DB\']),'.
'mysql_real_escape_string($this->nip, $GLOBALS[\'DB\']),'.
'mysql_real_escape_string($this->ulica, $GLOBALS[\'DB\']),'.
'mysql_real_escape_string($this->nr_domu, $GLOBALS[\'DB\']),'.
'mysql_real_escape_string($this->kod_pocztowy, $GLOBALS[\'DB\']),'.
'mysql_real_escape_string($this->miasto, $GLOBALS[\'DB\']),'.
'mysql_real_escape_string($this->nazwa_firmy, $GLOBALS[\'DB\']),'.
'$this->isActive)';
[PHP] pobierz, plaintext 

tak wyglada zapytanie

Kod

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '>username, $GLOBALS['DB']), mysql_real_escape_string($this->password, $GLOBALS['' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '>username, $GLOBALS['DB']), mysql_real_escape_string($this->password, $GLOBALS['' at line 1

a taki mam blad.

Oczekuję pomocy.

Pozdrawiam.

Ten post edytował Miszazdw 10.08.2009, 20:06:24

[Miszazdw]

[PHP] pobierz, plaintext 
            $query = 'INSERT INTO USERS (USERNAME, PASSWORD, ' .
            'EMAIL_ADDR, IMIE, NAZWISKO, PESEL, TEL_DOM, TEL_KOM, ' .
            'ULICA, NR_DOMU, KOD_POCZTOWY, MIASTO,' .
            'IS_ACTIVE) '.
            'VALUES'.
            '('.
            'mysql_real_escape_string("'.$this->username.'", $GLOBALS[\'DB\']), '.
            'mysql_real_escape_string("'.$this->password.'", $GLOBALS[\'DB\']), '.
            'mysql_real_escape_string("'.$this->emailAddr.'", $GLOBALS[\'DB\']),'.
            'mysql_real_escape_string("'.$this->imie.'", $GLOBALS[\'DB\']), '.
            'mysql_real_escape_string("'.$this->nazwisko.'", $GLOBALS[\'DB\']),'.
            'mysql_real_escape_string("'.$this->pesel.'", $GLOBALS[\'DB\']),'.
            'mysql_real_escape_string("'.$this->tel_dom.'", $GLOBALS[\'DB\']),'.
            'mysql_real_escape_string("'.$this->tel_kom.'", $GLOBALS[\'DB\']),'.
            'mysql_real_escape_string("'.$this->ulica.'", $GLOBALS[\'DB\']),'.
            'mysql_real_escape_string("'.$this->nr_domu.'", $GLOBALS[\'DB\']),'.
            'mysql_real_escape_string("'.$this->kod_pocztowy.'", $GLOBALS[\'DB\']),'.
            'mysql_real_escape_string("'.$this->miasto.'", $GLOBALS[\'DB\']),'.
            '"'.$this->isActive.'"'.
            ')';
[PHP] pobierz, plaintext 

Nadal lipa...