webwired Posted March 14, 2006 Share Posted March 14, 2006 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...[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>'; }[/code] Quote Link to comment https://forums.phpfreaks.com/topic/4980-datetime-not-working/ Share on other sites More sharing options...
kenrbnsn Posted March 14, 2006 Share Posted March 14, 2006 The date() function needs it's second parameter to be an integer. Use the strtotime() function to convert a string to an integer.[code]<?php $datetime = date("F j, Y, g:i A", strtotime($row[datetime])); ?>[/code]Ken Quote Link to comment https://forums.phpfreaks.com/topic/4980-datetime-not-working/#findComment-17552 Share on other sites More sharing options...
webwired Posted March 14, 2006 Author Share Posted March 14, 2006 Thank you, it worked, but I'm sure you already knew that... Anyways, thanks again. Quote Link to comment https://forums.phpfreaks.com/topic/4980-datetime-not-working/#findComment-17557 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.