In message <[EMAIL PROTECTED]>, suzithepid <[EMAIL PROTECTED]> writes >I have a real estate site where I input house listings and their data. >One of the fields in the MySQL database is called "sale_price." The >realtor wants me to place a running total at the top of the page of >all the sale prices. I am sure this is a simple thing to do, but being >a neophyte, it totally baffles me. Can someone show me what to do here?
Use the query "SELECT sum(sale_price) AS total FROM housestable" Then treat the field total as though it were a regular field. -- Pete Clark Sunny Andalucia http://www.hotcosta.com/comm_1.htm
