Re: [PHP3] problem trying to do different DB connections in a loop

In article <802568F7.003D93D7.00@acelondon.co.uk>, david.tansley@acelondon.co.uk wrote: > $sql="select name from sysdatabases"; > $sql_result=mssql_query($sql,$connection); > > $sql2="select > \"DEV\"=name, > \"FILE\"=filename, > \"MB\"=(size * 8) / 1024 > from sysfiles"; This looks pretty bogus... Should it not be: $sql2 = "select name as DEV, filename as FILE, (size*8)/1024 as MB from sysfiles"; -- Richard Lynch | If this was worth $$$ to you, buy a CD US Customer Support Director | from one of the artists listed here: Zend Technologies USA | http://www.L-I-E.com/artists.htm http://www.zend.com | (this has nothing to do with Zend, duh!)