Sorting question...kind of complex

[Anon]

Let's see if I can explain what I need to do. I have a bunch of movie reviews in my database, and I want to show all of them from the last 30 days on my index page. The tricky part is, I don't want those records to be arranged by date on the page, I want them to be alphabetical. I am sure there is a simple way to do this, but I am new and dumb. Can someone please help me?

If it helps to know, I am doing this site with Dreamweaver MX. My recordset is called rsSnide, and my fields for the date and the movie title are srDate and srTitle, respectively. I appreciate the help.

[Anon]

Hi,

Sql should be

$sql = "SELECT * FROM rsSnide ORDER BY srTitle";

Regards

Nilesh

[Anon]

NO it shouldn't! It should be:

$sql = "SELECT * FROM rsSnide WHERE srDate2 > NOW() - INTERVAL 30 DAY ORDER BY srTitle";

Although you really should replace the * with a full list of fields you want to pull out