Re: Re: running multiple updates on a single line
| From: | Robert Cummings | Date: | Tue, 04 Jul 2006 02:54:23 +0000 |
| Subject: | Re: Re: running multiple updates on a single line | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-239108@lists.php.net to get a copy of this message | ||
On Mon, 2006-07-03 at 22:47, João Cândido de Souza Neto wrote:
> Could any of these lines cousing an error?
>
> "Ryan A" <genphp@yahoo.com> escreveu na mensagem
> news:20060704012957.16338.qmail@web31701.mail.mud.yahoo.com...
> > Hi,
> > in phpmyadmin, in the SQL part where you can write a
> > query if I have a double update such as this:
> >
> >
> > it works without a problem as I am ending each sql
> > statement with a simicolon, but in my scripts when I
> > try to run multiple updates in a single line
> >
> > eg:
> > $xyz="update xyz set id=1 where id=0;update xyz set
> > id=3 where id=2;";
> >
> >
> > it does not work... any idea why?
RTFM :) -- mysql_query()
--
.------------------------------------------------------------.
| InterJinn Application Framework - http://www.interjinn.com
|
:------------------------------------------------------------:
| An application and templating framework for PHP. Boasting |
| a powerful, scalable system for accessing system services |
| such as forms, properties, sessions, and caches. InterJinn |
| also provides an extremely flexible architecture for |
| creating re-usable components quickly and easily. |
`------------------------------------------------------------'