Need Help with Upcoming Event

laduch

I have a problem with getting the upcoming event work.
Upcoming event is the first event in database after the day the site is visited.

in mysql database - day, month, year are "d" - int , "m" - int, "y" -int...
a example row

m d y
12 1 2007

I know it is a bad practice... I'm just using it for temporary

I only need to query out one event to database, the script is like:

$query = "SELECT *, STR_TO_DATE(CONCAT(y,'-',m,'-',d), '%Y-%c-%e') AS sort_date FROM events WHERE ADDDATE(NOW(), INTERVAL 300 DAY) = STR_TO_DATE(CONCAT(y,'-',m,'-',d), GET_FORMAT(DATE, 'INTERNAL')) ORDER BY sort_date DESC LIMIT 1";

$result = mysql_query($query, $dbconnect); 

while($row = mysql_fetch_array($result))
{ ...

Nothing is shown up... although I have about 10 events in the database.
Any idea?

__berfuzz

do you get anything if you leave out the AS things?

$query = "SELECT * FROM events ORDER BY date DESC LIMIT 1";

laduch

But there is no "date" field...

__berfuzz

Maybe you should rethink. Use timestamp! Then you'll only need one column for time/date or what you like to call it.

laduch

Yeah... that's last solution... I might add a field to save it...
Just troublesome...

__berfuzz

I beg to differ. Unix timestamp is the easiest way to store and retrive dates time etc. Unless you need 'day' and so on for some strange reason, just drop it! You'll get it using date strtotime strftime and your sql will be tidy.