[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

[eval(BadCode)]

list($isyr,$ismth,$isdd,$ishr,$ismin) = mysql_fetch_row(
    mysql_query(
        sprintf("
            SELECT 
              YEAR(ShowDateTime),
              MONTH(ShowDateTime),
              DAY(ShowDateTime),
              HOUR(ShowDateTime),
              MINUTE(ShowDateTime)
            FROM bookings 
            WHERE userid='%s'",
            mysql_real_escape_string($_SESSION[userid]))));

print<<<EOJ
var year={$isyr};
var month=($ismth};
var day={$isdd};
var hour=$ishr};
var minute={$ismin};
EOJ; 

Your problem is you are not converting the array from mysql_fetch_array/*big hint right there*/() into an integer correctly. The array you are converting to an integer really holds the interger it is that you want.

$month = array(12);
echo $month; #wrong
echo $month[0]; #correct, the values are indexed starting at 0. 

[thewebportfolio]

Thank you Extremely grateful for this! Working like a dream!