php - create array help

[flemingmike]

hi, im trying to create a date array based on the results of a query.  here is what i have

 

$query = "SELECT * FROM holidays"; 
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result)){
$holidays=$row['date'];		
}

 

im trying to get this to look something like this after i exit the }

 

$holidays=array("2012-12-25","2012-12-26","2013-01-01"); 

 

thanks!

[Pikachu2000]

$holidays[] = $row['date'];

[redarrow]

you set the database to a var char setting then you use the date function.

<?php
$update_date=date("d-y-m");
?>

you update to the database.

 

you then Paul them out with the code you provided.

 

 

but you want to do what put them back as a array what?

[flemingmike]

Thank!

[Pikachu2000]

you set the database to a var char setting then you use the date function.

 

NO. You store dates in a DATE field, not a VARCHAR field.

 

<?php
$update_date=date("d-y-m");
?>

you update to the database.

 

You do not store dates in that format. You store them from most-to-least significant digit, YYYY-MM-DD format, as is required by the DATE field data type. Otherwise you have to do all sorts of gymnastics to do any comparisons or math with them.

 

you then Paul them out with the code you provided.

 

 

but you want to do what put them back as a array what?

[redarrow]

i was told if i use the date function use strtodate() and var char for database.

 

so what can i do if i use the date database format any think interesting?

 

how it more easy that interesting lol

[Pikachu2000]

Here are all of the MySQL date & time functions. Most of them work only with YYYY-MM-DD (or YYYY-MM-DD hh:mm:ss) format.

[redarrow]

thank you so much your brilliant.