Hi guys,
I am trying to pull up data from my db in a unique way. I have an album release site where I display albums. http://www.album-releases.com What I'm trying to do is create a feed so I can display them on my other sites. So this is all I'm trying to do:
-Create a feed with the next 5 upcoming albums based on the date.
So if today is November 28th I want it to show the next 5 albums in the db, sound simple right? Ok, so if I have an album that comes out Nov 28th Dec5th Dec 14 Dec 17th Dec 18th I want to pull that info up based on todays date.
Right now I have this query
$results = mysql_query("Select * from Albums where Month >= '$curMonth' and Day >= '$curDay' and Year = '$curYear' ORDER BY Sort ASC LIMIT 5");
Right now it displays only 2 albums which are in the month of November and it doesnt show Decemeber. I hope this all makes sense, please ask any questions so I can clarify.
