mysql SELECT DATE

[murraywl]

I need a SELECT statement that converts the DATE from 2003-05-25 to May 25th and I need the statement to select the next five (5) rows from the table based on the today's date.

This is what I currently have:

SELECT actTitle, actDateStart
FROM smmbc_events

actDateStart is the field that contains the date for each row.

Thanks in advance!!!

Warren

[barand]

Take a look at DATE_FORMAT here

Use LIMIT 5 at the end of the query to restrict to first 5 rows found eg

"SELECT * FROM table WHERE ..... LIMIT 5"

hth

[murraywl]

I have the DATE_FORMAT working inside dreamweaver as testing, but when I publish to server, it will not display the actDateStart column and it displays a date before today's date.

I have 5 records displayed, but the actDateStart column will not display.

Here is the coding:
SELECT actTitle, DATE_FORMAT(actDateStart, '%b %D')
FROM smmbc_events
WHERE TO_DAYS(NOW()) + TO_DAYS(actDateStart) >= 14
LIMIT 5;

Thanks!!!

Warren

[barand]

Should there be a minus instead of a plus in that query?

Why not

$date = date('Y-m-d', strtotime('-14 days'));

$sql = "select actTitle, actStartDate from smmbc_events where " .
"actStartDate >= '$date' LIMIT 5 ";

Select the date as it is and format on display with

$displayDate = date ('M jS', strtotime($row['actStartDate']));

hth

[murraywl]

It was a little confusing for me... but I hacked away at it.

Thanks!!!