In message <moderators snip>, O'Brien, Kevin <[EMAIL PROTECTED] moderators snip> writes >Do you wanna get the total from the table ? or from row ?
I think that he means row. >if you wanna get the total from the table, i dont know do that in sql >code. >I think that you should do with php code. No, either SELECT SUM(exchangemb1e) FROM servers or SELECT SUM(exchangemb1e + exchangemb2e + exchangemb3e + exchangemb4e + exchangemb5e) FROM servers would do it, but it isn't relevant. I think that you got the answer that he wanted, an extra field at the end of the row. -- Pete Clark Sunny Andalucia http://hotcosta.com/Andalucia.Spain
