presently there is a table which records information about users enquiring for fares to a particular destination.

in the existing report which is a php file when a particular date is selected this php file will display the total number of enquiries for each destination and its price for a particular dates. in this php file a select query is executed along with GROUP BY and ORDER BY

ex=
DESTINATION        PRICE
sydney            1000
melbourne                        2500
perth            2000
sydney            2000
sydney            3000

my question is

1.
i would like to add all sydney fares and find the average and similarly for other cities. ex=

DESTINATION        PRICE
sydney            500
melbourne                        200

2.
i would like to display the city which had the maximum number of enquiries to the city with minimum enquiries in a descending order with the numeric value.

please provide the code for 1 and 2.

thanks in advance.

for the first one try this:

SELECT avg(price) FROM cities GROUP BY destination

About the second one: do you store the amount of inquiries in your database?


_________________
www.eb-downloads.com
FREE E-BOOKS DOWNLOADS.