On Mon, July 3, 2006 8:29 pm, Ryan A wrote: > 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?
PHP MySQL client disallows that as a crude stop for some SQL injection attacks. I believe that upcoming MySQL client libraries may put it back in. mysqli might even have it already. -- Like Music? http://l-i-e.com/artists.htm -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
