Re: running multiple updates on a single line

Ryan A wrote:

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?

try a newline between the queries then phpmyadmin will see them as separate queries and run them properly. -- Postgresql & php tutorials http://www.designmagick.com/