Re: mysql and php
| From: | Christian Reiniger | Date: | Thu, 05 Apr 2001 09:59:54 +0000 |
| Subject: | Re: mysql and php | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-47220@lists.php.net to get a copy of this message | ||
On Thursday 05 April 2001 02:15, you wrote:
> 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?
use separate queries
--
Christian Reiniger
LGDC Webmaster (http://sunsite.dk/lgdc/)
Error 032: Recursion error - see error 032