--- suzithepid <[EMAIL PROTECTED]> wrote: > 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? > > Thanks- > Suzi
SELECT SUM(sale_price) AS Total FROM table_name; You may want a WHERE clause to limit which rows are consulted, etc. SUM() is one of the "aggregate functions" for MySQL and others include MIN(), MAX() and AVG(). With the MIN() and MAX() and some arithmetic you could get a median of the houses listed (different than sold, of course). James Keeline
