[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]

Przerobiłem zapytanie z użyciem sprintf()

[PHP] pobierz, plaintext 
            $query = sprintf('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 ("%s", "%s", "%s", "%s", "%s", %d, %d, %d, %d, "%s", "%s", "%s", "$s", "$s", "$s", %d)',
                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 

i sql wywala ze nie zgadza się ilość kolumn z wprowadzanymi danymi.

Kod

Column count doesn't match value count at row 1