Jump to content


Photo

datetime not working


  • Please log in to reply
2 replies to this topic

#1 webwired

webwired
  • Members
  • PipPip
  • Member
  • 16 posts

Posted 14 March 2006 - 09:56 PM

I have read through php.net and even the datetime help on phpfreaks, all of which tell me this is the correct format for my datetime... This is what is in the mysql database 2006-03-14 15:04:24 in a datetime field, called datetime... this is what I am using to show it, $datetime = date("F j, Y, g:i A", $row[datetime]); Can anyone give me a hint as to what I am doing wrong? It outputs December 31, 1969, 7:33 PM. Here's my code...

include_once "../cgi-bin/connection.php";
$query = mysql_query("SELECT * FROM paybycheck WHERE paid = '0' ORDER BY datetime DESC");
    while ($row  =  mysql_fetch_array($query))    {
    $datetime = date("F j, Y, g:i A", $row[datetime]);
echo '<a href="paidbycheck.php?id=', $row[id], '">', $datetime . '     ' . $row[name] . '     ' . $row[city] . '     ' . $row[state], '</a><p>';
                                                }


#2 kenrbnsn

kenrbnsn
  • Staff Alumni
  • Advanced Member
  • 8,235 posts
  • LocationHillsborough, NJ, USA

Posted 14 March 2006 - 10:01 PM

The date() function needs it's second parameter to be an integer. Use the strtotime() function to convert a string to an integer.
<?php $datetime = date("F j, Y, g:i A", strtotime($row[datetime])); ?>

Ken

#3 webwired

webwired
  • Members
  • PipPip
  • Member
  • 16 posts

Posted 14 March 2006 - 10:06 PM

Thank you, it worked, but I'm sure you already knew that... Anyways, thanks again.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users