displaying a date

[jim.davidson]

 

I have a mysql table that has mutiple date fields.  I have some code that gets the date field that I'm looking for.

 

I then store that date to a variable.

$this_date = $row_getBus['feb_date'];

 

$this_date now contains 2010-02-22

 

I now want to display this as February 22, 2010.

 

I can't seem to be able to find a function that will do this.  Can anyone help me?

 

I will be greatfull for any help with this.

[PFMaBiSmAd]

http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_date-format

[JonnoTheDev]

Funily enough the function is called date(). http://php.net/date

print date("F d, Y", strtotime($this_date));

[jl5501]

try strftime("%B %d, %Y",strtotime($this_date));

[jim.davidson]

I had already tried what you suggest and I do see the date.  I'm missing somethig. Here's my code, (I'm a beginner so it is more then likely sloppy to all  you pros)

 

$bus_dates = array();

 

mysql_select_db($database_myData, $myID);

$query_getBus = "SELECT * FROM meetings WHERE type = 'Business'";

$getBus = mysql_query($query_getBus, $myID) or die(mysql_error());

$row_getBus = mysql_fetch_assoc($getBus);

// $totalRows_getBus = mysql_num_rows($getBus);

 

 

$counter = 0;

$today = date('Y-m-d');

 

$bus_dates[] = $row_getBus['jan_date'];

$bus_dates[] = $row_getBus['feb_date'];

$bus_dates[] = $row_getBus['mar_date'];

$bus_dates[] = $row_getBus['apr_date'];

$bus_dates[] = $row_getBus['may_date'];

$bus_dates[] = $row_getBus['jun_date'];

$bus_dates[] = $row_getBus['jul_date'];

$bus_dates[] = $row_getBus['aug_date'];

$bus_dates[] = $row_getBus['sep_date'];

$bus_dates[] = $row_getBus['oct_date'];

$bus_dates[] = $row_getBus['nov_date'];

$bus_dates[] = $row_getBus['dec_date'];

 

// Find the next meeting date

 

for ($counter=0; $counter <12; $counter++) {

  if ($bus_dates[$counter] >= $today) {

    echo "<BR>$bus_dates[$counter]";

    exit;

  }

}

 

$display_date = date("F d, Y", strtotime($bus_date));

echo $display_date;

[jl5501]

you have exit in your for loop. I think you mean break;

 

exit will stop the script

[jim.davidson]

Thank you jl5501

So I'm not going crazy.  The exit comes from my days as a Clipper programmer.  In that language you used exit to get out of a loop.

[JonnoTheDev]

What is incorrect is that the variable $bus_date has no value. It has never been initialised anywhere.

[jl5501]

ah ok, I never did clipper

 

did cobol, then c and pascal before php