Help Im lost..

[bucfan99]

I am building a PHP/html page. when opened it pulls data from an external db and stores it locally as an xml file. The webpage pulls data from the locally stored xml. I need a line that selects the highest # out of these 3 lines on the xml and assigns it a name.
On the xml they look like this:
<atm-0>82190</atm-0>
<atm-1>109190</atm-1>
<atm-2>91895</atm-2>
so now it would select atm-1 and assign it also as "$highatm"

[harlowhair]

You should really perform these types of operations directly in the SQL. Why do you need to use an XML file? It would be easier to read the data directly into PHP from the db, and order the results e.g.

SELECT * FROM tblname WHERE criteria ORDER BY atmvalue DESC

That way the first row will be the highest, second row will be next highest etc.

or if you only want the top value then build your select statement like:

SELECT MAX(atmvalue) FROM tblname WHERE criteria

Hope this helps