I am working with a table that has existing data in it..

The 'date' column has its data like so:

Saturday, September 26, 2015
Saturday, September 26, 2015
Saturday, September 27, 2015
Saturday, September 27, 2015

etc..etc..

Using PHP (or maybe just straight MySQL?) how can I only pull/list records (data) that are BEFORE a certain date (todays date)

Something like this.. but with the way the 'date' (cough) is in the3 table. I'm not sure how to handle it properly.

```
SELECT s.sessioncode, s.sessionname, s.sessiontime FROM fc15_sessions AS s  WHERE s.sessiondate < **TODAYS_DATE** ORDER BY s.id

```

Testing with some PHP and messing with that 'date' format...

This seems to work and be something I can work with... but not sure how I put it together in a validation:

```
$string = 'Saturday, September 26, 2015';
$timestamp = strtotime($string);

echo "DATE CHECK: " . date("Y-m-d H:i:s", $timestamp);

```

MySQL Attempt:

```
SELECT s.id, s.sessiondate, s.sessioncode, s.sessionname, s.sessiontime
FROM fc15_sessions AS s
WHERE STR_TO_DATE(s.sessiondate, '%m/%d/%Y' ) > date( "m/d/Y" )
ORDER BY s.id

```