substring question

[chasethemetal]

So I have a database with a bunch of dates in it. In this format 05/15/2011. And this is how I get that out.

 

$data = mysql_query("SELECT * FROM location ORDER BY id ASC") or die(mysql_error());

 

while($info = mysql_fetch_array( $data )) {

 

  $date = $info['date'];

};

 

echo "$date";

 

The resulted echo would be 05/26/2011

 

How do I get $date to echo out JUST 05? I'm trying to isolate the month. I think the method is using substrings, but I havent had any luck.

 

Thanks any help would be great!

[wildteen88]

Use extract

list($month, $day, $year) = explode('/', $row['date']);

 

EDITED

[dougjohnson]

OR - $justmonth = substr($date,0,2);

[xyph]

Is your 'date' column a varchar or MySQL date column?

 

If it's a date column, you can just use

 

SELECT MONTH(`date`) as `date_month` FROM `location` ORDER BY `id` ASC

 

Then use $info['date_month']

[chasethemetal]

Thanks!!! Works great.