mySQL.. help please :)

[JAY-ESSENTIAL]

I need to view all records which are in the range : (today + one month)
dateline_from is my date time (UNIX format).

I know how to convert UNIX to normal date time its FROM_UNIXTIME(date,format).

How would i do this... Using MySql ??

a bit of statment which might help

SELECT * FROM `event` WHERE FROM_UNIXTIME( `dateline_from` , format)

 

[JAY-ESSENTIAL]

If you're using 31 days as a month, just do everything from now() to now() + (86400 x 31)

So what would the SQL statment be if `dateline_from`is my start date