[RESOLVED] MySQL Data - date and time to PHP

[thewebportfolio]

Hello,

I'm wondering if anyone can help me.

I have a countdown clock which has the following fields i need to populate

code:
--------------
var year= ;
var month= ;
var day= ;
var hour= ;
var minute= ;

I have created a date and time field in MySQL called 'ShowDateTime' and this field will contain different dates and times depending on the session userid $_SESSION['userid'].

i have tried the following code which works by populating the fields, although it shows the words NaN (Not a Number) on view.

code:
--------------
<? $isyr=mysql_fetch_array(mysql_query("SELECT EXTRACT(YEAR FROM ShowDateTime) FROM bookings WHERE userid='$_SESSION[userid]'"));

$ismth=mysql_fetch_array(mysql_query("SELECT EXTRACT(MONTH FROM ShowDateTime) FROM bookings WHERE userid='$_SESSION[userid]'"));

$isdd=mysql_fetch_array(mysql_query("SELECT EXTRACT(DAY FROM ShowDateTime) FROM bookings WHERE userid='$_SESSION[userid]'"));

$ishr=mysql_fetch_array(mysql_query("SELECT EXTRACT(HOUR FROM ShowDateTime) FROM bookings WHERE userid='$_SESSION[userid]'"));

$ismin=mysql_fetch_array(mysql_query("SELECT EXTRACT(MINUTE FROM ShowDateTime) FROM bookings WHERE userid='$_SESSION[userid]'")); ?>

var year=<? echo $isyr; ?>;
var month=<? echo $ismth; ?>;
var day=<? echo $isdd; ?>;
var hour=<? echo $ishr; ?>;
var minute=<? echo $ismin; ?>;



How can i make is so when i extract the date and time into the required fields, it brings through the numbers not text? or NaN.

Hope this makes sense.

Many Thanks