mysql and php
| From: | Augusto Cesar Castoldi | Date: | Thu, 05 Apr 2001 00:15:48 +0000 |
| Subject: | mysql and php | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-47144@lists.php.net to get a copy of this message | ||
I'm sending this command to mysql
UPDATE fusuario u, fgrupos g SET g.cdgrupo=1, u.celular="99823640",
u.nome="Augusto X", u.sobrenome="Cesar Castoldi",
u.cidade="Florinópolis",
u.emailpessoal="augusto.castoldi@uol.com.br", u.idade="19",
u.sexo="M",
u.operadora="T", u.email="", u.ddd="048" WHERE g.cdgrupo=1 and
u.cdusuario=g.cdusuario and u.cdusuario=1 and u.celular="99823640" and
u.ddd="048" and u.ativo=1 and g.ativo=1
and I receive this error message:
Mensagens do MySQL : You have an error in your SQL syntax near 'u, fgrupos
g SET g.cdgrupo=1, u.celular="99823640", u.nome="Augusto X", u.sobren' at
line 1
Why? How can I update with 2 or more tables?
regards,
Augusto