Re: Query for MySQL

In article <BAY7-F62Sr7fUULExlM0001d142@hotmail.com>, codesmoker@hotmail.com says... > Question. > > I am looking to try and pull the last modified date out and display it. So > lets say I have 1000 records. I want to only display the date of the last > modified time, I dont care about the id or the name or anything. How do I > query for that? Given that you don't say what your table structure is and what database you are using, I'll be generic in my response. Try either using max() to select the greatest 'last modified date' value, or select 'date' and order by date DESC and use LIMIT 1 to just get the most recent date (if your db supports LIMIT) -- Quod subigo farinam $email =~ s/oz$/au/o;