I nearly have my problem figured out, but have one question…

My SQL statement reads as follows:

sql = "SELECT * FROM upcoming_dvd order by stdate,title asc"

What I want is for it to display the earliest Street Date (stdate) in the DB and only that date and then order those by title (so if the earliest stdate is 2/17/2004, then display all those titles that have that street date). But I’m having trouble doing that. Any ideas as to what my SQL statement would be?

So I guess I want to select a distinct date (the earliest in the DB) and only display that date and the titles associated with it.

Any ideas?