running multiple updates on a single line

From: 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

« previous php.general (#239105) next »