running multiple updates on a single line
| From: | Ryan A | Date: | Tue, 04 Jul 2006 01:29:57 +0000 |
| Subject: | running multiple updates on a single line | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-239105@lists.php.net to get a copy of this message | ||
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?
Thanks!
Ryan
------
- The faulty interface lies between the chair and the keyboard.
- Creativity is great, but plagiarism is faster!
- Smile, everyone loves a moron. :-)
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com