Using PHP to select table entries using two date fields and current month?

$thismonth contains a UNIX timestamp returned by mktime The timestamp for hour 0, minute 0, second 0 of month 8 of this year is 1312862400. That's not 8.

$thismonth contains a UNIX timestamp returned by mktime. The timestamp for hour 0, minute 0, second 0 of month 8 of this year is 1312862400. That's not 8.

Don't put that in your query, put date('n') (8) in it... or just let MySQL do it $query = "SELECT ec_display,ec_event_name,ec_start_date,ec_end_date FROM event_calendar WHERE month(ec_start_date) = MONTH(CURRENT_DATE) OR month(ec_end_date) = MONTH(CURRENT_DATE) ORDER BY ec_start_date.

Wow Dan, thanks for the quick response! Your suggestion works great, how can I pull the list for next month using month(current_date)? – Nina Aug 9 at 5:27 Try MONTH(CURRENT_DATE + INTERVAL 1 MONTH).

– Dan Grossman Aug 9 at 5:33 Works like a charm! I'm getting all emotional because I'm so grateful for the help. – Nina Aug 9 at 5:46 Can I ask for one more thing?

How to display only the month and day from the ec_start_date and ec_end_date? – Nina Aug 9 at 5:46 In your PHP code after retrieving the row from the query, you can use date to format the dates however you want, as you did with the month numbers earlier. For example, echo date('F jS', strtotime($row'ec_start_date')); to get something like "August 9th".

– Dan Grossman Aug 9 at 5:48.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.