Hi,
i am having a table with a Date type as one field
now i am having a query in which some dates are getting selected from that table
now what i want is to extract the year field from all those dates
how can i do that?
do u hav e some ideas

here is some snippet that i am giving to u
==========================================================

$query = “select release_date from ball_details group by release_date “;

$numresults=mysql_query($query);

while ($row= mysql_fetch_array($numresults))
{
$t = $row[“release_date”];
/// // i dont KNOW WHAT TO DO FROM HERE ///////
//$t1 = $t(“Y”);
//$temp_array_for_release_date[$h] = $t;
//$h++;

}

==========================================================
-ashish

Also in #PHP _↴