PHP echoes something different than what is returned in MySQL

[duckduckgoose]

When I run the following query at the mysql prompts, I get the expected results:

SELECT CONCAT(LEFT(DATE_FORMAT(event_start, '%M'),3),' ',DATE_FORMAT(event_start, '%d')) from event

The above will spit out Oct 15

But, when I process it through php and echo the row, it comes out as Oct 0

huh?!

$casql = "SELECT CONCAT(LEFT(DATE_FORMAT(event_start, '%M'),3),' ',DATE_FORMAT(event_start, '%d')) AS event_start_date from event";

$cares = db_query($casql);

while($rowc = db_fetch_array($cares)) {

echo '<div class="event-date">'.$rowc['event_start_date'].'</div>';

}

I even changed the query to separate out the day:

SELECT LEFT(DATE_FORMAT(e.event_start, '%M'),3) as event_start_month, DATE_FORMAT(e.event_start, '%d') as event_start_date, DATE_FORMAT(e.event_start, '%h:%m %p') as event_start_time, DATE_FORMAT(e.event_end, '%h:%m %p') as event_end_time FROM event e ORDER BY e.event_start DESC

And I still get 0 as the day, event though the sql results comes back as indicated below.

+-------------------+------------------+------------------+----------------+
| event_start_month | event_start_date | event_start_time | event_end_time |
+-------------------+------------------+------------------+----------------+
| Oct               | 12               | 03:10 PM         | 05:10 PM       | 

[bretticus]

Why separate the date components if you are going to combine them in the query? For example, what happens if you query:

$casql = "SELECT DATE_FORMAT(`event_start`, '%b %e') AS 'event_start_date' from `event`";

$cares = db_query($casql);

while($rowc = db_fetch_array($cares)) {

echo '<div class="event-date">'.$rowc['event_start_date'].'</div>';

}