Hi,
I wonder if someone can help me...
I am trying to extract the date into three different variables ready to go into three option boxes for the user to update a person's date of birth.
I am using the following to split up the day, month and year:
$queryDate = mysql_query("SELECT YEAR(playerDOB), MONTH(playerDOB), DAY(playerDOB) FROM player WHERE playerID='$playerID'") or die (mysql_error());
Now I have tried this within the database and can see that it splits it up. The problem I am having is being able to access them in variables. How do I go about accessing the year, day and month separately from the $queryDate variable?
Appreciate the help in advance!