how to generate a mysql date and compare it with a PHP date

In PHP, I have two date string generated by using the function of "mktime" like below:

$date_begin = mktime ....
$date_end = mktime ....

now in mysql I have an "event" table with columns of
(event_id, month, day, year)

Now I want to see if any event falls between $date_begin and $date_end.

Can someone help me to write the following query ?

===
$sql = "SELECT * FROM event where date(year-month-day) >= $date_begin AND date(year-month-day) <= $date_end";

$result = mysql_query ...

In MySQL, use the function UNIX_TIMESTAMP() to convert your dates into EPOCH time.

$date_begin = mktime ....
$date_end = mktime ....

$sql = "select * from events where unix_timestamp(concat(y,'-',m,'-',d)) BETWEEN $date_begin AND $date_end";