HTML page returns wrong date even though DB date is correct?

filch

Helo to all again,

I have another weird problem. I have several scripts (pages) that get input from a MySQL DB and the date is returned just fine but I have one page, the one that simply lists the index of what is in the table, which always returns Dec 31/1969. Now I know there is some bug with this particular date but I do not know how to fix it. AND, as I said, it only happens on one of my scripts. \

Can anyone help?

filch

the_Igel

I'm almost sure you use php date() function to format some date information from MySQL. The problem is that date() needs time in UNIX timestamp format, whereas MySQL uses different types. You need to use unix_timestamp mysql function:

instead of
SELECT ... date as mydate ... FROM table ....
use
SELECT ... unix_timestamp(date) as mydate FROM table ...

and then you do
echo date('format_string', $row['mydate']);

filch

Hi,

Actually, I am using the following syntax so it should work .. at least I think it should. Any comments or suggestions?

filch

if (mysql_num_rows($result) > 0)
{
// iterate through resultset
// print title with links to edit and delete scripts
while($row = mysql_fetch_assoc($result))
{
?>
<?=$row['slug'] ?> [<?=formatDate($row['timestamp']) ?>]

filch

Hi again,

I thought actually that I should add the query portion of the code in as well. ?Perhaps I need to do something in thhe query portion?

filch

$query = "SELECT id, slug, timestamp FROM faq ORDER BY timestamp DESC";
$result = mysql_query($query) or die ("Error in query: $query. " .
mysql_error());

// if records present
if (mysql_num_rows($result) > 0)
{
// iterate through resultset
// print title with links to edit and delete scripts
while($row = mysql_fetch_assoc($result))
{
?>
<?=$row['slug'] ?> [<?=formatDate($row['timestamp']) ?>] 
<a href="faq_edit.php?id=<?=$row['id'] ?>">edit</a> | <a
href="faq_delete.php?id=<?=$row['id'] ?>">delete</a>
 
<?

filch

Hi again,

Well, I am embarrassed to say that it was a stupid mistake on my part --- inexperience I guess ;-)

I had mixed up two syntaxes.

To start with I was using an array as in: while($row = mysql_fetch_assoc($result))

Than I was outputting the results to the page with :

which is fine. Then for the date, I was using object oriented syntax (duh!!1) like so:

<? echo formatDate($row->timestamp); ?>

So when I finally noticed that, I swithed it to:

<?=formatDate($row['timestamp']); ?>

and voila ... a properly formatted date.

Man talk about blind. Oh well, it is working now and I am happy. Thanks for everyone's replies.

Cheers,

filch